SUMIF

Posted on 18-01-2020 , by: admin , in , 0 Comments

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.service450 =SUMIF (C4:C12,E18,E4:E12)

 

 

Leave a comment