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

"sunshine.girl" wrote:

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?