.

SUMIF Function Dictionary

Function Dictionary Function Examples Function Categories

SUMIF            
 
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.

.

Popular posts from this blog

TAMIL NADU Seventh MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 7TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD

TAMIL NADU Sixth MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 6TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD