Latest Post

6/recent/ticker-posts

Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example



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.  


Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example



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. 

Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example

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. 

Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example

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. 


Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example

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.



Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example

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.


Use of Excel Static Formulas Count, Counta, Countblank, Countif and Countifs with Example

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

टिप्पणी पोस्ट करें

0 टिप्पणियां