Learn how to use the Excel SUMIF function with clear examples and syntax. Perfect for beginners and advanced users looking to master conditional summing..
use the SUMIF function to sum the values in a range that meet criteria that you specify.
For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF(B2:B25,”>5”)
Syntax
SUMIF(range, criteria, [sum_range])
See also:
Exercise: Use the SUMIF function to calculate the total sales for all products sold in the month of January.
Sample Date:
| Month | Product Category | Sales |
|---|---|---|
| January | Food | 10 |
| January | Clothing | 20 |
| January | Electronics | 30 |
| February | Food | 20 |
| February | Clothing | 30 |
| February | Electronics | 40 |
Exercise: Use the SUMIF function to calculate the total sales of Food in the following table:
| Month | Product Category | Sales |
|---|---|---|
| January | Food | 10 |
| January | Clothing | 20 |
| January | Electronics | 30 |
| February | Food | 20 |
| February | Clothing | 30 |
| February | Electronics | 40 |
Exercise: In the following table, calculate the total sales for all products sold on March 8th:
| Date | Product | Sales |
|---|---|---|
| March 7th | Product A | 100 |
| March 7th | Product B | 200 |
| March 8th | Product C | 300 |
| March 8th | Product D | 400 |
Exercise : In the following table, calculate the total sales for all products sold to customers in the Pakistan:
| Customer | Country | Sales |
|---|---|---|
| Customer A | Pakistan | 100 |
| Customer B | Canada | 200 |
| Customer C | United Kingdom | 300 |
| Customer D | Pakistan | 400 |