How to use "COUNTA" Function in Excel

This function counts the number of numeric or text entries in a list.It will ignore only blanks.

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

Example:

Here is the video tutorial of the same for clear understanding.

Back to MS Excel>>