How to sum cells depending on the content of a neighbor cell
- by dannymcc
I have an Excel document with the following columns;
Date | Reference | Amount
23/01/11 | 111111111 | £20.00
25/09/11 | 222222222 | £30.00
11/11/11 | 111111111 | £40.00
01/04/11 | 333333333 | £10.00
31/03/11 | 333333333 | £33.00
20/03/11 | 111111111 | £667.00
21/11/11 | 222222222 | £564.00
I am trying to find a way of summarising the content in the following way;
Reference : 111111111 Total: £727
So far the only way I have been able to achieve this is to filter the list by each reference number (manually) and then add a simple SUM formula to the bottom of the list of amounts.
Are there any tricks that anyone knows that may speed this up?
What I am trying to achieve is a spreadsheet that highlights each reference number that collectively exceeds over £2,000.