CountA Worksheet Function

by Linda Quinn

Close Window        Print Page


=CountA(value1, value2, . . . )




Returns the number of non-blank cells in a range.

It will count text blanks like cell A6 and logical values like A4.

SYNTAX:

=CountA(value1, value2, . . . )




Example:
=COUNTA(A1:A6) returns 5.

  A B
1     300         
2     Chicago         
3              
4     TRUE         
5     1500         
6     " "         









Copyright © 2006-2016, LQSystems,Inc. All rights reserved.