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.