EXCEL FUNCTION – COUNTA

EXCEL FUNCTION – COUNTA

How to use “COUNTA” function in Excel

COUNTA function is used to get the total count of Any-value or Non-Blanks in range.

COUNTA Function has one required argument i.e. value1, and optional argument i.e. [value2].

Syntax:
=COUNTA(value1,[value2],...)
Syntax Description:

value1 argument is used to give any value/ range for which count is required

[value2] argument is used to give another value /cell reference/range

means, we can add multiple value/cell reference/range by separating them with comma ( , )

Example 1: COUNTA function with cell range:
  • “Column A and B” has Any values,
  • “Column C” shows the sample formula applied and,
  • “Column D” shows the output of the function,
COUNTA Function Excel Tricks

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs

Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business