SUMIF Function (Functions in Excel)

Item	Date	Cost
Brakes	1-Jan-98	80
Tyres	10-May-98	25
Brakes	1-Feb-98	80
Service	1-Mar-98	150
Service	5-Jan-98	300
Window	1-Jun-98	50
Tyres	1-Apr-98	200
Tyres	1-Mar-98	100
Clutch	1-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)

What Does It Do ?
This function adds the value of items which match criteria set by the user.
Syntax
=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)
=SUMIF(C4:C12,"Brakes",E4:E12)			This examines the names of products in C4:C12.
			It then identifies the entries for Brakes.
			It then totals the respective figures in E4:E12
=SUMIF(E4:E12,">=100")			This examines the values in E4:E12.
			If the value is >=100 the value is added to the total.
Formatting
No special formatting is needed.

Related Posts by Categories