Monday, March 3, 2014

Count nonblank cells in Excel

=COUNTA(A2:A6)Counts the number of nonblank cells in the list above (3)
=COUNTA(A2:A3, A6)Counts the number of nonblank cells in the top two, and bottom cell in the list (1)


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)