Sumif multi criteria and delete

[vip2612]

Hi,
My data are
A B C D E
1 Type Person Product Total Status
2 AB Peter A 700 1
3 AN Sam B 800 2
4 AB John J 700 3
5 SG Luck A 400 1
6 AN Jam B 500 2

i want when the which row have same A and C (Row 3 and 6) and the status is 2,it will sum D and delete row 6,status is keep row 3 ,it mean 1.
the data i wan when run marco is

A B C D
1 Type Person Product Total
2 AB Peter A 700
3 AN Sam B 1200
4 AB John J 700
5 SG Luck A 400