countif problem

  • Thread starter Thread starter SteveG
  • Start date Start date
S

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
 
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?
 
Frank,

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

Steve
 
Back
Top