SUMIF example in Microsoft Excel
Monday, July 23rd, 2007SUMIF
This function in fact resembles the SUM function, that is to add a number within a range of cells.
The word “IF” means this sum was added up with the certain conditions.
The syntax is:
SUMIF(range,criteria,sum_range)
The example below may be easier to see.
| A | B | C | |
| 1 | Item | Total | Stock |
| 2 | A | 300 | 1 |
| 3 | B | 90 | 2 |
| 4 | C | 125 | 3 |
| 5 | D | 200 | 4 |
| 6 | E | 70 | 5 |
| 7 |
..
|
Try these formulas in cell C7 |
Result |
| =SUMIF(B2:B6,"=300",C2:C6) | 1 |
| =SUMIF(B2:B6,">=125",C2:C6) | 8 |
| =SUMIF(B2:B6,"<500",C2:C6) | 15 |
| =SUMIF(A2:A6,"A",C2:C6) | 1 |
| =SUMIF(A2:A6,">C",C2:C6) | 9 |
| =SUMIF(A2:A6,"<C",C2:C6) | 3 |