Sum for adjacent column of matching references

[MrM-X]

Hi,

If anyone can assist, it would be a real help

I have a table with a column of repeating references. Lets call them MR1. Alongside is a second column with figures which vary. So we get A1:A5 with MR1 and B1:B5 with a random numerical sequence. Below we have MR2 in column A and another set of numbers in column B.

What I need to do is get a sum of all of the figures in column B which have the shared MR1 ref. Then the same for MR2 and so on. There is no consistent pattern with the number of matching refs in column A.

I have 500 or so groups so a formula will save oodles of time vs manually summing each block.

Is there a way to do this?

Thank you!

[FlameRetired]

Hello MrM-X. Welcome to the forum.

Text descriptions seldom give enough detail.

Please note the instructions for attaching an Excel workbook in the 'gold' banner at the top of each page.

[MrM-X]

Thank you FlameRetired, example attached. I hope this helps to illustrate what I need.

[AliGW]

In D2 copied down:

=IF(A3=A2,"",SUMIF($A$2:$A$25,A2,$B$2:$B$25))

[MrM-X]

AliGW, thank you so much, this is perfect for me with adjustment of absolute refs to fit my main dataset.

Wonderful, thank you very much indeed.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.