| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
turning text into a calculated result:
Hello all
I have a spreat sheet that looks something like this: Cases Total cigarettes 13*10*20 2,600 13*10 130 12*10*20 2,400 with col A as "Cases" & column b "total ciggies" basically I want a formula to calculate the sum in col A to display the result in col B without having to manually into the calculation each time & without using "Text to Columns" if possible any help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula, not the result is displayed in calculated cells - why? | Excel Worksheet Functions | |||
| Pivot Table: How do I hide calculated items that result in zero? | Charts and Charting in Excel | |||
| PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
| Shifting Calculated Result - Re-Issued | Excel Worksheet Functions | |||
| Shifting Calculated Result | Excel Worksheet Functions | |||
Threaded Mode
