View Single Post
  #2   Report Post  
PCLIVE
 
Posts: n/a
Default 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?