View Single Post
  #1   Report Post  
sunshine.girl
 
Posts: n/a
Default How do you get the sum of 2 different text values?

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?