- Joined
- Sep 12, 2009
- Messages
- 26,487
- Likes received
- 6,761
- Thanks received
- 1,926
- Location
- Null island
A Employee ID B Month C Amount D Total for Month (Calc: =IF(AND(A2=A1,B2=B1),0,C2)
1235 1 25.00
1235 1 15.00 40.00
1235 2 25.00 25.00
1235 3 125.00 125.00
2569 2 25.00
2569 2 15.00 40.00
2569 3 300.00
2870 3 25.00 325.00
What I need is a calculation in column E which will sum Column D at each change of reference in column A
I spent ages lining up all those numbers which now look fine whilst I am editing but all group together when I post![]()
There you go
Code:
A Employee ID B Month C Amount D
Total for Month (Calc: =IF(AND(A2=A1,B2=B1),0,C2)
1235 1 25.00
1235 1 15.00 40.00
1235 2 25.00 25.00
1235 3 125.00 125.00
2569 2 25.00
2569 2 15.00 40.00
2569 3 300.00
2870 3 25.00 325.00



Quite happy to record macro's but not really any good at writing them! Can kind of understand what you've written - will this still work if the number of rows vary? I can't give a definitive end point

I also love spreadsheets which is why I still get involved with this stuff (probably much to the annoyance of the team who'd far rather I was off playing golf or something
)