### Latest Post

4/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.

## 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.