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) | |||