| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I sum numbers from cells that contain text
I would like to combine numbers and text in the same cell, and sum the
numbers at the bottom of a column. Is there a way I can do this? The text has no numerical value, and I wish the function to ignore it entirely. Example of what I need: art show 10 trade show 18 store 14 42 (total of numbers in cells) Any clues appreciated! -Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Adding cells with numbers and text | Excel Worksheet Functions | |||
Threaded Mode
