Hello friends its Sachin here with another blog on Count Ifs function of excel. In this blog we going to learn the following things about Count ifs function

1.) Syntax and insight of Count Ifs Function

2.) Uses with Practical example

3.) Things to be taken care of while using it

Count Ifs Function Short and Sweet – The Count ifs Function is useful when you want to want to know how many cells are in database that meets a certain criteria specified by you.

Syntax and insight of Count ifs Function

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Criteria Range 1 – whenever in any formula we say Criteria range 1 it means a table from which we want to evaluate the criteria

Criteria 1 – Required The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, “>32”, B4, “apples”, or “32”.

Criteria range 2 and criteria 2 -these are to be filed when you want to evaluate more than one criteria

(Important – all the criteria range should have same number of rows and columns

Uses of Count Ifs with practical Examples

Example -1 Count Ifs with 1 conditions

Explanation – In the below image the right most table indicatecounted the number of times Dhoni Score 1,2,3,four,sixes

Example -2 Countifs with two conditions so as to find the total sale of laptop when its more than 350000 so as to find our Big customers

Explanation – In this example we have taken two criteria 1st is that product should be laptop and second that the total sale of the product should be more than 350000


Example -3 Countifs to find the number of transaction that took place in particular month

Explanation – here we have used two criteria to find the number of transaction that took place in month

Things to be taken care of

1.) Each additional range must have the same number of rows and columns as the criteria_range1 argument.

2.) If the criteria argument is a reference to an empty cell the  CountIfs function treats the empty cell as a 0 value.

3.) Up to 127 range/criteria pairs are allowed.

4.) you can use the wildcard characters— the question mark (?) and asterisk (*) — in criteria. A question mark matches any single character, and an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

We will talk more about using wild card * and ??? in another blog

Thank you for reading the blog

comment below in case of any query and fell free to give your opinion about blog

One thought on “Count Ifs and its use in Excel

Leave a Reply

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