COUNTA formula

 COUNTA formula 

This Formula is used to count the value in one or more cells (This will count the cells irrespective of Number or Text value)

Example - 1

= COUNTA(A1:A5)

Answer = 5 

Note :- This formula count both, that is, Text and Numeric Value. Here Cell A3 included.

Result Below