| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of columns that vary in position
I need to sum up the total of all numbers in columns titled Assy. These
columns will vary in position in the spreadsheet. example of data Fabs Assy Fabs Assy Assy Expediting - Shortages 0 0 0 0 0 Inspection 0 48 0 0 0 Housekeeping 26.6 49.6 8 0 0 Maintenance 0 0 0 0 0 Rework 0 5.9 0 115 0 Waiting 0 0 0 73 0 Communications 26.6 47.3 0 41.5 0 Training 12 40.5 37 0 209 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make excel hide columns when it says cannot move objects | Excel Discussion (Misc queries) | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
