Hello,

Hoping that someone out there can help this newbie with a problem.

I have a spreadsheet, where Column A shows a number which could be
duplicated further down the sheet.
The number of times this is duplicated may be as many as 5 times
(max).

What i would like, is to SUM the values in column B, where the Numbers
in Column A match, and show the result in column C.
See the example below:-
Number 1 appears 3 times, and the sum of Column B for each of these
number 1 inputs is 20.

eg.
Col A Col B ColC
1 10 20
1 5 20
1 5 20
2 20 30
2 10 30
3 5 5
4 42 42
etc..

Can anybody please help?

Thanks in advance.
Mike