| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding columns containing numbers with dashes
I have several columns (formatted as text) containing numbers with
dashes, i.e., 20-1 15-2 30-4 05-3 Is there a way to add up the numbers separately in the column, i.e, one total for the 20, 15, 20, 05 and one total for the 1, 2, 4, 3. If unable to add both is it possible to add up just the numbers to the left of the dash? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Dashes to a 25 digit alphanumeric cell | Excel Discussion (Misc queries) | |||
| Adding and subtracting many columns numbers | Excel Worksheet Functions | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL | Excel Worksheet Functions | |||
| problem with adding columns of numbers | Excel Worksheet Functions | |||
Threaded Mode
