Saturday, 3 September 2016

Excel COUNTIF | How to use the Excel COUNTIF function | Best Excel Tutorial



Excel COUNTIF examples



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.










 

No comments:

Post a Comment