How do you get the sum of 2 different text values?

S

sunshine.girl

For instance, I need to add the amount of times "S" and "HS" appear in a row.
I figured out that the COUNTIF function will add the amount of times "S"
appears in a row, but I can't figure out how to make it add both and give me
a number value as the answer. Is this even possible?
 
S

sunshine.girl

I just got the answer, if anyone is curious. The formula would read as
follows: =COUNTIF(B10:AF10,"S")+COUNTIF(B10:AF10,"HS")
 
D

Dave Peterson

One more:
=SUM(COUNTIF(B10:AF10,{"S","HS"}))



sunshine.girl said:
I just got the answer, if anyone is curious. The formula would read as
follows: =COUNTIF(B10:AF10,"S")+COUNTIF(B10:AF10,"HS")
Click to expand...
 
Top