If [x] then add up a range

[excelnovice1981]

Please can you help with this problem - See table below:

I would like to put a formula in Colum C that adds up the total per person. So it needs to:

a) find everyone with the same name in Column A (e.g. everyone called John)
b) look in the corresponding row in Column B and add up all of those numbers (e.g. for John add $10 + $12 + $8)
c) return the sum in the first row for each person (e.g. C2 for John) and leave all other cells in Column C blank (e.g. C3 and C4 for John)

I have a large data set and just need to copy and paste formula down the coulmn
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Income[/TD]
[TD]Total Income per person[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]$10[/TD]
[TD]$30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John[/TD]
[TD]$12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]John[/TD]
[TD]$8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Mary[/TD]
[TD]$5[/TD]
[TD]$28[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Mary[/TD]
[TD]$7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Mary[/TD]
[TD]$9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Mary[/TD]
[TD]$7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Stephen[/TD]
[TD]$6[/TD]
[TD]$6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Try

C2 copied down
=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")

M.

 

[excelnovice1981]

Wow, thank you!

 

[Marcelo Branco]

You are welcome.

M.