How do you get the sum of 2 different text values?
Try this:
=COUNTIF(A:A,"S")+COUNTIF(A:A,"HS")
Regards,
Paul
"sunshine.girl" wrote in message
...
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?
|