SUMIF Function in Excel Tutorial, by Kevin Stratvert on YouTube. 11 min 27 s.
- Video length
- 11 min 27 s
- Time to do it
- 15 minutes
- Difficulty
- Easy
- Steps
- 8
What you need
Steps
Click the cell where you want the total. Type =SUMIF( to start the formula. Excel will show the argument names as you type.
Select the range to check, such as the category column, then type a comma. This is the range argument.
Type the criteria in quotes, like "Books", then a comma. This is the value Excel must match.
Select the range holding the numbers to add, such as the sales column. Close the bracket and press Enter.
To match partial text, put wildcards in the criteria. Use "*book*" to catch any cell containing book, or "?" for a single character.
For more than one condition, type =SUMIFS(. The sum range comes first, then each criteria range and its criteria in pairs.
Add a second pair, such as a region column and "North", separated by a comma. Close the bracket and press Enter.
Check the result against a manual filter of the same rows. If the total looks wrong, click the cell and confirm each range has the same size.
Tips and common mistakes
SUMIFS puts the sum range first, while SUMIF puts it last, so do not mix up the order.
Text criteria need quote marks, but a plain number like 100 does not.
All ranges in one SUMIFS formula must be the same height and width or Excel returns an error.
Use cell references for criteria so you can change the value without editing the formula.
Questions
What is the difference between SUMIF and SUMIFS?
SUMIF handles one condition and takes the criteria range before the sum range. SUMIFS handles one or many conditions and takes the sum range first.
Can I sum values greater than a number?
Yes. Put the operator in quotes with the number, like ">500", as the criteria. You can also join a cell reference, like ">"&B1.
Why does my SUMIF return 0?
The criteria probably does not match the cell text exactly, or the sum range holds text instead of numbers. Check for extra spaces and number formatting.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
