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?
PS: Try: =COUNTIF(C1:C11;"><")
This simpler formula works as well.
I trust this helps (more?).
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
