Use Of Count-if
Item
|
Date
|
Cost
| ||||
Brakes
|
01-Jan-98
|
80
| ||||
Tyres
|
10-May-98
|
25
| ||||
Brakes
|
01-Feb-98
|
80
| ||||
Service
|
01-Mar-98
|
150
| ||||
Service
|
05-Jan-98
|
300
| ||||
Window
|
01-Jun-98
|
50
| ||||
Tyres
|
01-Apr-98
|
200
| ||||
Tyres
|
01-Mar-98
|
100
| ||||
Clutch
|
01-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.
|
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें