sumif
What Does It Do?
This function adds the value of items which match criteria set by the user.
Syntax
=SUMIF(Range Of Things To Be Examined, CriteriaToBeMatched, RangeOfValuesToTotal)
=SUMIF(C4:C12,”Brakes”,E4:E12)
=SUMIF(E4:E12,”>=100″)
Formatting
No special formatting is needed.
Item | Date | Cost |
Brakes | 01-Jan-98 | 80 |
Tyres | 10-May-98 | 25 |
Brakes | 01-Feb-98 | 80 |
Service | 01-Mar-98 | 150 |
Service | 05-Jan-98 | 300 |
Window | 01-Jun-98 | 50 |
Tyres | 01-Apr-98 | 200 |
Tyres | 01-Mar-98 | 100 |
Clutch | 01-May-98 | 250 |
Total cost of all Brakes bought. | 160 | =SUMIF(C4:C12,”Brakes”,E4:E12) | ||
Total cost of all Tyres bought. | 325 | =SUMIF(C4:C12,”Tyres”,E4:E12) | ||
Total of items costing £100 or above. | 1000 | =SUMIF(E4:E12,”>=100″) |
Total of item typed in following cell. | service | 450 | =SUMIF (C4:C12,E18,E4:E12) |