COUNTA does not count empty cells.
The COUNTA function returns the count of values in the list of suppliedarguments.
COUNTA takes multipleargumentsin the formvalue1,value2,value3, etc.
Arguments can be individual hardcoded values, cell references, or ranges up to a total of 255 arguments.
Empty cells are ignored.
To ignore empty strings,this example provides a workaround.
Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers.
COUNTA does not count empty cells.
Cells that contain text, numbers, errors, spaces, etc.
Formulas that return empty strings ("")arecounted as blank.
