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