.

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

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download