How to sum cells depending on the content of a neighbor cell

Posted by dannymcc on Super User See other posts from Super User or by dannymcc
Published on 2011-11-21T16:37:16Z Indexed on 2011/11/21 17:56 UTC
Read the original article Hit count: 290

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.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about automation