If function and counta

[Jenny]

I'm trying to figure out how to write a formula that will
count text cells that only say "Unex". If a cell has this
value, then I want it to be counted, if the cell doesn't
have this value, I want it to be ignored.
Any ideas
=IF(C37:AH37=Unex,COUNTA(C37:AF37),0)
This is what I have but it doesn't work. I don't know how
to have it recognize a specific value in a cell.

 

[Peo Sjoblom]

How about

=COUNTIF(C37:AF37,"Unex")

or

=COUNTIF(C37:AF37,"*Unex*")

 

[Jason Morin]

Try:

=COUNTIF(C37:AF37,"Unex")

or if the word "Unex" is embedded with other characters
(like "Foa Unex Tae") but you still wish to count it:

=COUNTIF(C37:AF37,"*Unex*")

HTH
Jason
Atlanta, GA