View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gibsol gibsol is offline
external usenet poster
 
Posts: 25
Default 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