Summing the third column

[ECEK]

I have two columns: ID and No

The first column has a list of clients. The second is a numerical amount.
I'm looking for a formula that sums the No's for the grouped clients in column 1.

It should look like this when finished.

ID No SUM per ID
1 10 43
1 15 43
1 8 43
1 6 43
1 4 43
2 9 20
2 5 20
2 4 20
2 2 20
3 6 62
3 3 62
3 1 62
3 2 62
3 5 62
3 45 62
4 8 8

I guess its a mix between VLookup and SumIfs but Im struggling.

At present I have to extract the data to Access and creat a Grouped query then link it back.

 

[Ranman256]

Use Group button.

 

[ECEK]

Found it !!! =SUMIF(A:A,A2,B:B)

 

[Rx_]

Thanks for posting your solution!
Since you are starting down the slope with SumIF, there are times the SumProduct will be needed. Alternatively, a "helper" column could be created.
However, if the datasets are huge (e.g. 30K rows) with multiple columns, this can overwhelm the processor.
Just in case the next level is needed for larger datasets, here is a link.
http://www.mrexcel.com/forum/excel-...-alternative-sumif-conditional-statement.html