COUNTIF
 

I need to count how many cells in a column contain anything, hence not
counting blank ones.

=COUNTIF(range,criteria)

what would the criteria be?

=COUNTA(a1:a10)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"luvthavodka" wrote in message
...
I need to count how many cells in a column contain anything, hence not
counting blank ones.

=COUNTIF(range,criteria)

what would the criteria be?

=COUNTA(Range)

would skip empty cells but will include a cell with ="".
luvthavodka wrote:
I need to count how many cells in a column contain anything, hence not
counting blank ones.

=COUNTIF(range,criteria)

what would the criteria be?

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Just to follow the subject line:

=COUNTIF(A:A,"<")

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"luvthavodka" wrote in message
...
I need to count how many cells in a column contain anything, hence not
counting blank ones.

=COUNTIF(range,criteria)

what would the criteria be?