What Does It Do? This function counts the number of items which match criteria set by the user. Syntax =COUNTIF(Range Of Things To Be Counted, Criteria To Be Matched) 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.
|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)|