COUNTA Function in Excel with Example

COUNTA ()

This function counts the number of numeric and text entries in a list.

Best view in desktop mode.

	A	B	C	D
1	Values		Count
2	50		8
3			=COUNTA(A2:A10)
4	Andrew
5	20%
6	Simple
7	25.52
8	9-Mar-20
9	#DIV/0!
10	FALSE
11

• It ignores blanks cells.
• It can handle up to 255 arguments or ranges.

Syntax

=COUNTA(Range1,Range2,Range3... through to Range30)

Formatting

No special formatting is needed. The result will display as normal text.

Functions for Counting

Ø  To count only numbers, use COUNT()

Ø  To count numbers and text value, use COUNTA()

Ø  To count based on one criteria, use COUNTIF()

Ø  To count based on multiple criteria, COUNTIFS()

Ø  To count blank cells, use COUNTBLANK()

COUNT in Excel

<<  Previous

Next  >>

COUNTIF in Excel