countif problem

[SteveG]

I am using a countif function in numerous cells. I have 30 or so cell
that refer to the same range of cells but for different tex
information. My formula is very basic:
countif(G29:G49,"Passed AEP").

It works great except for one thing, it only works for some of th
references. i.e.

countif(G29:G49,"Passed AEP") works but

countif(G29:G49,"Passed AIG") does not.

Each countif function is in a different cell and the range it i
referencing populates based on its own function. I made sure the tex
in the range matched the text in the countif function exactly. I jus
can't seem to figure out the problem. It is very sporadic. If anyon
can help, I would appreciate it greatly.

Thanks,
Stev

 

[Frank Kabel]

Hi
probably some spaces or other invisible characters in your range G2:G49
check manualy with a formula like
=G29="Passed AIG"´
Does this return TRUE?

 

[SteveG]

Frank,

I thought I had already eliminated that possibility but your suggestio
proved me wrong. Thanks for the assistance.

Steve