Aggregating rows based on unique ID

[TWDC]

Hi all,

I have data in the form;

Paul 23
Paul 24
Rob 37
susie 33

Where I need a third colum which sums up each persons column two entries into one cell. so;

Paul 23
Paul 24 47
Rob 37 37
susie 33 33

Thanks in advance,

PJ

[JarvisDS]

Assume that you have a range for your Column A Names that is A1:A4
The range for Column B numbers would be B1:B4
In the third column, you use a SUMIF function.
Next to the first name, Paul, in C1 would be the forumla =SUMIF(A1:A4,A1,B1:B4)
You could copy this formula to cells C2:C4 if you add the $ signs to hold the ranges constant.
=SUMIF(A$1:A$4,A1,B$1:B:$4)

[NBVC]

If the names are grouped together as sample, then assuming data starts in A2 and B2, then in C2 enter:

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

copied down.

Else if names are mixed up and duplicates are not grouped try:

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

[TWDC]

amazing thanks both