.

COUNTIF Function Dictionary

Function Dictionary Function Examples Function Categories

COUNTIF      
 
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
How many Brake Shoes Have been bought. 2 =COUNTIF(C4:C12,"Brakes")
How many Tyres have been bought.   3 =COUNTIF(C4:C12,"Tyres")
How many items cost £100 or above.   5 =COUNTIF(E4:E12,">=100")
Type the name of the item to count. service 2 =COUNTIF(C4:C12,E18)
What Does It Do ?        
This function counts the number of items which match criteria set by the user.
Syntax          
=COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched)
The criteria can be typed in any of the  following ways.
To match a specific number type the number, such as =COUNTIF(A1:A5,100)
To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,"Hello")
To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,">100")
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