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:

=COUNTIF(Range,Condition)

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.

=COUNTIF(A2:D300,”>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!