COUNTA Formula Excel with Example.

How to use COUNTA Formula in MS Excel / COUNTA Formula With Example/ Function with Example in Microsoft Excel.

Every Excel user should have knowledge / information about COUNT Function, as COUNTA Formula is a very important formula in MS Excel. In this Example we will learn What exactly COUNTA Formula do in Excel or How to use COUNTA Formula in MS Excel? Also what is the Difference between COUNTA & COUNT Formula?

COUNTA Function or COUNTA Formula counts the number of cells in a range that have data in them. If you+ want to count the number of cells that contains data, then COUNTA function / formula will be used. COUNTA Formula can be used in Microsoft Excel 2003, 2007, 2010, 2013 or any version of Microsoft Office MS Excel.

Difference between COUNTA & COUNT Formula in Excel:-

As we already discuss about COUNT Formula, COUNT Formula counts cells only that contains numbers not any other data but COUNTA formula counts all the cells that contains data either the data is numeric (Number) or any other data type.

What is the SYNTAX of COUNTA Formula in Excel?

SYNTAX:- =COUNTA(range) or =COUNTA(value1, value2....valueN)

NOTE:- COUNTA counts all cells that have any data, if you want to count only cells that contains numeric (number) values then use COUNT formula instead of COUNTA.

COUNTA Example:-

We have a data that contains some data doesn't matter what is the type of data either it's numeric or any other type, COUNTA formula will simply count the cells that contains any type of data. Below is an example:-

COUNTA Formula Excel

Please give your suggestions and comments in comment box. Thanks.