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

	A	B	C	D	E
1	Name	Income	Total Income per person
2	John	$10	$30
3	John	$12
4	John	$8
5	Mary	$5	$28
6	Mary	$7
7	Mary	$9
8	Mary	$7
9	Stephen	$6	$6

<tbody>
</tbody>

 

[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.