Just wondering why I cannot get countif function to work.
A
04
03
09
01
12
02
06
etc…
=COUNTIF(A1:A152,"=09") always results in 0.
Nevermind, apparently the data had some invisible padding after each number
so it wasn’t a match.
On 01/06/2012 20:40, GofBorg wrote:[color=blue]
Just wondering why I cannot get countif function to work.
A
04
03
09
01
12
02
06
etc…=COUNTIF(A1:A152,“=09”) always results in 0.[/color]
This is because that COUNTIF is looking for a text string of =09
If that column data really is text, then simply change it to
=COUNTIF(A1:A152,“09”)
Michael
“I’ve got the key to the gates of paradise, but I’ve got too many legs!”
This is because that COUNTIF is looking for a text string of =09[color=blue]
If that column data really is text, then simply change it to
=COUNTIF(A1:A152,“09”)[/color]
Actually no, there are numerous correct syntax for matching.
Yours is one, mine is another and there are other acceptable queries.
I wouldn’t have guessed it was correct either, but I just read up on
the subject ant to me it is easier to read and understand the logic.
That’s why I added the equals. Turned out the issue was a hidden
character from the data import. I got rid of it throughout and now
it’s all peachy. Thanks for the assist though!