| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum #'s in a cell that has text AND numbers?
I don't know if this is possible, but thought it was worth asking. Is there
a function in excel where it will add the numbers in a cell based on the text that's in it? For example, here's what I want to do: A1: S=8.0 A2: (blank) A3: V=8.0 A4: S=4.0 Based on the cells listed above, what formula can I use to get the following? S=12.0 V=8.0 Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Extract numbers from cell with Text and Numbers | New Users to Excel | |||
| Using numbers as numbers in a cell having text | Excel Discussion (Misc queries) | |||
| text and numbers same cell and formulas still work (like lotus) | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
