You close the month with fifteen hundred sales rows and need the total of a single region. You filter, select, read the sum in the status bar, and for the next region you do everything again.
How to use SUMIF Formula step by step
1. Choose one or two conditions
SUMIF for a single criterion, SUMIFS when two must hold at once.
2. Give the sum range and the range being tested
Usually different columns of the same size: amounts on one side, regions or months on the other.
3. Write the criterion and copy
Operator and value; the tool decides whether it needs quotes, wildcards, or the decimal kept outside the text.
The Step Count: Traditional Friction vs. KorexTools
Filtering region by region and reading the status bar (4 steps)
- Apply the region filter.
- Select the amounts column.
- Read the sum in the status bar.
- Copy the value by hand and repeat for the next region.
With the KorexTools “SUMIF Formula” builder (3 steps)
- Choose one or two conditions.
- Give the ranges and criterion.
- Paste the formula and reuse it by changing only the value.
SUMIF and SUMIFS do not order their arguments the same way, and that is where the error is born
In SUMIF the range being tested comes first, then the criterion, and the range to add comes last. In SUMIFS the order flips: the range to add comes first, followed by pairs of range and criterion. Anyone who moves from one to the other without rereading the help ends up with zeros or #VALUE! and no idea why.
The tool honours each order and builds the criterion by the same rules as the counting tool: text in quotes, numbers without them, wildcards if you pick "contains", and decimals kept outside the text so they become a comma when you choose the semicolon style. With 1500.5 in a ">=" condition, the formula writes ">="&1500,5 and a Spanish Excel understands it.
When SUMIF is enough and when it is not
- •A single filter, such as "all North sales": SUMIF.
- •Two filters at once, such as North and above 1500: SUMIFS.
- •A filter by date or month: SUMIFS with two conditions on the same date column.
Argument order
| Function | First argument | Sample formula |
|---|---|---|
| SUMIF | Range being tested | =SUMIF(A2:A100,"North",C2:C100) |
| SUMIFS | Range to add | =SUMIFS(C2:C100,A2:A100,"North",B2:B100,">=1500") |
| Decimal condition | Criterion kept outside quotes | =SUMIF(B2:B100,">"&1500.5) |
Common Mistakes and How to Avoid Them
- ⚠️Adding a range with numbers stored as text: Excel skips them.
- ⚠️Using the same range to test and to add without meaning to.
Frequently Asked Questions
Why does my SUMIF return zero?
Usually the criterion does not match: an extra space, a number stored as text, or a sum range of a different size from the tested one.
How do I add by month when I have full dates?
Use SUMIFS with two conditions on the same column: greater than or equal to the first day of the month and less than the first day of the next.
Can wildcards be used?
Yes, with the "contains", "begins with" or "ends with" operators. They work on text only, not on numbers.
What I would do if I were in your shoes
«A conditional sum that returns zero is rarely broken: usually the criterion does not match how the data is written. Look at the data before the formula.» — DataKorex Engineering Team.