ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sum of cells (https://www.excelbanter.com/excel-programming/309814-sum-cells.html)

No Name

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



All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com