M
Mik
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
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