| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing Text & Numbers
I need to sum a range of cells that will contain both text and numbers. The
text will always be an "s" and the number will be a number between 0.25 and 10, in multiples of 0.25. The entry in the cells to be counted will be entered as "s.25" or"s.5.50", for example, and the number following the "s." needs to be totaled. There will be some blank cells in the range. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Cells with Text and Numbers | Excel Worksheet Functions | |||
| Summing Text with Numbers | Excel Discussion (Misc queries) | |||
| Summing Numbers and Text in same cell | Excel Discussion (Misc queries) | |||
| Help with summing numbers in cells that also contain text | New Users to Excel | |||
| summing cells with text and numbers | Excel Worksheet Functions | |||
Threaded Mode
