Counta not counting correctly!!

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
 
M

Meenie

Nevermind, should have used countif, lol. Where is my head today? (don't
answer that!!)
 
M

Mike H

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

Problem not counting duplicates 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Autofilter COUNTA formula not taking into account hidden cells 1
Problems with count, counta and countifs 3
COUNTA counting formulas as well. 2
Count formula issue 8
Percentages in Pivot Tables 1
Pivot Table COUNTA SUM of Unhidden cells only 1

Top