sum numbers using a special criteria

[kevinross713]

I have 4 columns
**A B C D
1 56 1 56 5 What I want to see
2 57 2 57 7
3 58 3 58 9
4 56 4
5 57 5
6 58 6

What can i put in cell D1 to add the numbers in column B when the value in column A = the value in column C1

 

[Oaktree]

Welcome to the board.

D1=SUMIF($A$1:$A$6,C1,$B$1:$B$6) copied down