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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with count, counta and countifs 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Problem not counting duplicates 1
COUNTA Confusion.... 8
Need help with Count, Counta, Countif 2
COUNTA - ADDING CELLS 5
Autofilter COUNTA formula not taking into account hidden cells 1
counting blank cells within two columns 2

Back
Top