- Joined
- Jun 2, 2006
- Messages
- 5,386
- Likes received
- 508
- Thanks received
- 221
- Location
- Colchester
I have a huge amount of data in a spreadsheet which has 5 workbooks all linked to each other - I need to subtotal a column according to when a reference changes in another column, in two workbooks, without using subtotal (have tried it and Excel falls over). I have a feeling that a simple IF/SUM function should work but I cannot work it out and now I have a headache - can anyone help 


