COUNTIF 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 |
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. |
0 comments:
Post a Comment