COUNTIFS Function in Excel

Hello friends,

                 Today I am going to post another useful function of count, i.e. Countifs

It will be available in office 2007 and later version.

With the above mentioned example it will be easy to understand that how can we use this function:

In this example we have to search for how many Pen are there in the column A1:A10 and the formula  will be as follows :-

=COUNTIF(A2:A10,"Pen")

But if condition is as follows :-
i.e. Pen having quantity more than 10 nos. then the formula will be as follows

Pen

>10

=COUNTIFS(A2:A10,"Pen",B2:B10,">=10")

I think now it will be easy to understand the use of countifs function.

My next post will be the same on countifs function again with more example.

Thanks and have a nice day!

Narendra