Thread: sum of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default sum of cells

Acct:03,003,1
Regular: 96 OverTime: 17
Vacation: 8
UNAprTM: 2 FamMedLA: 2
Acct:03,003,2
Regular: 57 OverTime: 8.5
Vacation: 12
Prem 2: 77 OT Prem2: 8.5
UNAprTM: 0.5 FamMedLA: 8
Acct:03,003,3
OverTime: 16 OT Prem3: 16

Given the above sheet, for every account, I would like to
sum Regular, Overtime and UNAprTM. My problem is that I
can't think of a logical way of getting this sum because
an account has anywhere from 1-6 lines.

Would appreciate any help.

Thanks