CountA

M

martialtiger

How can I prevent CountA from counting cells with forumlas? I though
CountA counts only cells in a range that contain a value.

Here's the scenario:

I have a formula: > =IF('Alex P.'!D10="","",AVERAGE('Alex P.:Vinutha G.'!D10))

And this forumla runs down column C. Now in another cell I want t
count only the cells down column C that display an actual figure. Hop
this makes sense.

Thanks for the help!

:cool
 
F

Frank Kabel

Hi
you ran into a typical Excel problem. The formula result "" is not
intrepreted as empty cell by COUNTA. One workaround would be to use the
following array formula (enter with CTRL+SHIFT+ENTER)
=SUM(IF(C1:C100<>"",1,0))
or the non array version:
=SUMPRODUCT(--(C1:C100<>""))

HTH
Frank
 
Top