If function and counta

  • Thread starter Thread starter Jenny
  • Start date Start date
J

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.
 
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
 
Back
Top