Skip to main content

COUNT, COUNTIF & COUNTIFS Function

When are they used:

COUNT :- To count the number of cells that contain numbers, use the COUNT function. 


=COUNT(B39:B50)

COUNTIF :- To count cells based on one criteria (for example, less than 150), use the following COUNTIF function.


COUNTIFS :- To count cells based on multiple criteria (for example, R Madrid and greater than 30), use the following COUNTIFS function.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share via
Copy link
Powered by Social Snap