Counta not counting correctly!!

  • Thread starter Thread starter Meenie
  • Start date Start date
M

Meenie

Ok, I'm tearing my hair out.
I have Excel 2003.
I have a very simple formula to count the number of "yes" answers in a
column but it isn't calculating correctly.
=counta(c22:c29,"*y*") should = 8 (In this instance all the answers are yes)
but instead it is returning an answer of 9.
There are no hidden rows or columns. What could cause this?
I have many other columns to apply this formula to, many of them are much
longer than this one which I can easily see isn't coming out correctly - I
need to know my formula is working correctly!
thanks, Meenie
 
Nevermind, should have used countif, lol. Where is my head today? (don't
answer that!!)
 
Hi,

COUNTA is the wrong function, try this

=COUNTIF(C22:C29,"Yes")

or if you mean contains the string yes among other words try this

=COUNTIF(C22:C29,"*Yes*")

Mike
 
Back
Top