At 11:59 14/11/2008 -0600, Roy Cabaniss wrote:
I have a list of fruit [...] and [...] if the fruit is citrus as
noted by the c besides them in column A. The third column selects
the fruit if it is a citrus (as noted by column A)
apples
c oranges oranges
blueberry
pomegranate
...
so the formula in column 3 looks like =IF(A1="c";B1;"") but when I
counted column c I came up with 11, not the 4 I expected.
=counta(c1;c11) Am I doing something wrong or is this normal?
As the help text for COUNTA() makes clear, it counts the number of
values - even text and even empty strings. So =COUNTA(C1;C11) will
give the answer 2, not 11. And =COUNTA(C1:C11) (what you presumably
meant) will give 11, since there really are 11 values in the range C1:C11.
Try: =COUNTIF(C1:C11;"><""")
This counts the number of cells which are not a null string.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
