Excel COUNTA Function

LQ Net Home







   Excel Links

CountA Worksheet Function

   Printer Friendly Page

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-2009, LQ Systems,Inc. All rights reserved.