| 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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
How do you get the sum of 2 different text values?
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? |
|
#4
|
|||
|
|||
|
How do you get the sum of 2 different text values?
One mo
=SUM(COUNTIF(B10:AF10,{"S","HS"})) sunshine.girl wrote: 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? -- Dave Peterson |
| Reply |
| 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) | |||
Linear Mode
