| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
adding values with text
Is there any way to sum up cells if they contain text and letters. For
example I would like to sum up 6cs and 12cs for a total of 18. Is there a function where I can make an If statement that would have a condition such as endswith "cs"? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| Adding two text cells together | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
