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
|