Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example
Today we discuss in this post Use of Excel Static Category Formulas Count, Counta, Countblank, Countif and Countifs so please read carefully this post for better understanding.
COUNT
This Formula in excel we count only numeric cells.
Syntax
COUNT(Number1, Number2,…)
Number 1 – The first item, cell reference, or range within which you want to count numbers.
Number 2 – Up to 255 additional items, cell references, or ranges within which you want to count numbers.
Example :- In this sheet we want how many items, then use this formulas =Count(B2:B11) and press Enter your Result display 10 means in this sheet 10 Items.
COUNTA
This Formula in excel we count cell ranges numbers and text both.
Syntax
COUNTA(Number1, Number2, …)
Number 1 – The first argument representing the numbers that you want to count.
Number 2– Additional arguments representing the numbers that you want to count, we count up to a maximum of 255 arguments.
Example :- In this sheet we want how many items, then use this formulas =Counta(A2:A11) and press Enter your Result display 10 means in this sheet 10 Items.
COUNTBLANK
This Formula in excel count only Blank cells.
Syntax
COUNTBLANK(range)
Range from which you want to count the blank cells.
Example :- In this sheet we want how many Blank Cells, then use this formulas =Countblank(A1:A11) and press Enter your Result display 3 means in this sheet 3 blank cells.
COUNTIF
The COUNTIF function use to conditionally COUNT the values which match the given single criteria.
Syntax
COUNTIF(range, criteria)
range – One or more cells to count, including numbers or names.
criteria – A number, cell reference, or text string that defines which cells will be counted.
Example :- In this sheet we want how many items, including name LET’S BUY IT, then use this formulas =Countif(E2:E11,”LET’S BUY IT”) and press Enter your Result display 8 means in this sheet 8 cells including LET’S BUY IT.
COUNTIFS
The COUNTIFS Formulas is used to conditionally COUNT the values which match the multiple criteria.
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
criteria_range1-The first range in which to evaluate the associated criteria.
criteria1 – The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted.
criteria_range2-The second range in which to evaluate the associated criteria.
criteria2 – The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted.
Example :- In this sheet we want how many items, qty greater then 10 and grade including name LET’S BUY IT, then use this formulas = Countifs(B2:B11,”>10″,E2:E11,”LET’S BUY IT”) and press Enter your Result display 7 means in this sheet 7 cells qty greater 10, including LET’S BUY IT.
Conclusion
I hope after reading this post you better understanding Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs. If any question and suggestion for me pleas ask we try your answer reply soon.
Also Read-
How To Create Mail Merge Using Word and Excel in Hindi
