Watch Excel Tutorial Video – Excel Function – SUMIF
How to use “SUMIF” function in Excel
SUMIF function is used to get the “total sum” of values for matching criteria across range.
SUMIF Function has two required arguments i.e. range, criteria and optional argument i.e. [sum_range].
Kindly note, [sum_range] is optional ONLY in-case where criteria and [sum_range] are in ONE column, but if, criteria and [sum_range] are in DIFFERENT columns then [sum_range] is NOT optional.
=SUMIF(range, criteria, [sum_range])
range argument is used to give the range of cells in which criteria needs to find,
criteria argument is used to give criteria for sum. We can give value (example “A”,”A*” >10, 50 ) or cell reference# (example: E2) in this argument,
sum_range argument is used to give cell range; those are to be added together as per the criteria mentioned above.
Example 1: SUMIF function with various criteria:
Here, we have sales for various Locations and want to get the total sales as per the criteria given in function:
- “Column A to B” has sales details,
- “Column D” shows the sample criteria, that is applied,
- “Column E” shows the sample formula applied,
- “Column F” shows the output of the function and,
- Explanation is provided in Columns “G & H”
We will be using SUMIF function as follows:
Things to Remember:
– Criteria argument can also work with Wild characters i.e. asterisk (*), question mark (?). Asterisk will find any series of characters and Question mark will find a single character.
– If you want to search actual * or ? (Asterisk or Question Mark) then type tilde (~) before * or ?
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons: