CountA Worksheet Function

by Linda Quinn

Close Window

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 6.

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






=================================================================
This content was created by Linda Quinn of LQNet.

See http://www.lqnet.com for a great collection of articles on this and other topics.

=================================================================
Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.


====================================================================
Want an expert to help with your project?    LQ Systems, Inc.   Business Solutions
====================================================================