Excel countif formula

Whenever you need to count the elements inside data series the excel countif formula is available to help you reach your target easy and fast.

The Countif formula has the following structure:


Note that the Range can be a large table not only one column.

Examples of Excel Countif Formula

Let’s say we need to count all the elements inside a table that have greater values than 100.


If we have more than one condition to apply, then the COUNTIFS formula comes in and enables us to address more than one attribute.

The structure is:

=COUNTIFS(Criteria Range1, Criteria 1, Criteria Range2, Criteria 2, ….)

Good luck excelling!


Author has written 295 articles

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.