View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PointerMan PointerMan is offline
external usenet poster
 
Posts: 33
Default Where to begin???

Part Jobs Total
A 10 5 25 5 220 999 ?
B 10 5 70 5 999 ?
C 10 5 60 220 999 ?
D 4 10 35 5 220 999 ?
E 5 70 100 20 5 220 ?
....
6700 rows deep x 50 columns wide

If Job 5 takes 1 day, Job 10 takes 1 day, Job 25 takes 3 days, etc what's
the easiest way to sum the total number of days for each part? I could do it
manually, but I don't want 50 sub-calculations in my formula.