Excel Tips No 24 : The Art of Counting Function

This free microsoft excel tips no 24 is telling The Art of counting Function. May be you often use count function. In this tips I will share how to count with a certain condition.

In this case we use COUNTIF function

General form of COUNTIF function is :
=COUNTIF(Range that will be put a criteria,Criteria)

For example, see the example below


1.Count in column "Mounth" where month is equal to January
=COUNTF(B4:B15,"January)

2.Count in column "Mounth" if Month not equal to January
=COUNTIF(B4:B15,"<>January")

3.Count in column "Mounth" if Month equal to January or Month equal to February. You can use "+" to represent "OR" Function
=COUNTIF(B4:B15,"january")+SUMIF(B4:B15,"February")

4.Count all Cost that only more than 100
=SUMIF(D4:D15,">100")

May this tips can be usefull for you.