COUNTA Formula - counts nonblank cells

Theory:
=COUNTA(Range)
Example:
=COUNTA(A2:A8)
The COUNTA formula counts the number of cells in a range that are not empty. it does not distinguish between different datatypes.

Read More..