Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I LOOKUP text values | Excel Worksheet Functions | |||
How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
how do i detect like text and add corresponding values? | Excel Discussion (Misc queries) | |||
text and values combined in one cel | Excel Discussion (Misc queries) |