=SUMIF(A1:A100,1,B1:B100)
will sum all the B cells which have corrsponding A cell values of 1
Looking at you example:
=SUMIF($A$1:$A$100,C1,$B$1:$B$100)
entered in C1 and copied down the column
Of course, you will need to adjust the A1:A100 range
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Mik" wrote in message
oups.com...
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