Thursday, October 17, 2013

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.

0 comments:

Post a Comment

www.cineclouds.com. Powered by Blogger.