The Count, CountIf & CountIfs Function

Count | CountIf | CountIfs

In this post we will learn Count functions.

Count

The Count function counts the range of cells or occurrence of a value which contains Numeric values. See below snapshot:

CountIf

The CountIf function counts the values based on a criteria. 

See Example 1 & Example 2 in below snapshot.

Example 1. In this example we have count the values which are greater than 40.

Example 2. In this example, we have count the occurrence of "Gautam".

CountIfs

The CountIfs function counts the values based on multiple criteria. In below example we have put 2 criterias "Gautam" & ">=30". You can put more criteria as per your requirement.

If you see below snapshot, Gautam have 3 entries in below snapshot however only 2 values are Greater than 30 (Highlighted in green). Our function gave the output 2.

Thanks for learning Count functions, will come soon with different functions.

-----------------------------------------------------------------------------------------------------------------------------------------------

Download the file : Count/CountIf/CountIfs.xlsx 

Please share your feedback in comments, if you feel its helpful.