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-2019, LQSystems,Inc. All rights reserved.