Watch Excel Tutorial Video – 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].
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,
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: