Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
COUNTA Function / Formula in Microsoft Excel 2007 | Video Tutorial

COUNTA Function

The COUNTA function finds and returns the count of number of numeric entries, text, errors, etc in a given list. This ignores blank cells.

Formula:


=COUNTA(Value 1, Value 2,...)
Whereas Value 1, Value 2,... are items which can be numbers, text or error value whose count have to be found

Video Tutorial:


Let us learn to find the count of the numeric entries, text, errors, etc from the given list using COUNTA function with the help of the below video

Learn MS Excel


Ask Questions

Ask Question