I have a spreadsheet which has 5 workbooks. The first workbook references the second via Vlookup primarily and the second references the first, third, fourth and fifth again using Vlookup. The second workbook contains almost 10,000 rows which represents 6 months data; the spreadsheet will need to be used cumulatively as it represents a reconciliation.

My problem is that I need to compare totals for individuals according to month; the easy way would be to use the Subtotal function but, unfortunately the spreadsheet appears to have to much data/too many calculations to enable the process to work and therefore I need a formula which will sum data in a list at the point that a reference number changes:

A Employee ID B Month C Amount 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 then need is a calculation that will give me a total for employee 1235 for months 1, 2 and 3 and then the same for the other employees.

I hope I have explained this in a way that makes sense and any help you can give will be much appreciated.

(really sorry but I can't get the columns to line up when I post the thread)

My problem is that I need to compare totals for individuals according to month; the easy way would be to use the Subtotal function but, unfortunately the spreadsheet appears to have to much data/too many calculations to enable the process to work and therefore I need a formula which will sum data in a list at the point that a reference number changes:

A Employee ID B Month C Amount 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 then need is a calculation that will give me a total for employee 1235 for months 1, 2 and 3 and then the same for the other employees.

I hope I have explained this in a way that makes sense and any help you can give will be much appreciated.

(really sorry but I can't get the columns to line up when I post the thread)

Last edited: