Struggling with Formula

[nsnodgrass73]

I need Column E to return the value of adding Column D if Column B AND Column C match. So if column b and c match in row 1 I need E2 to add 89.74 and 24.00 and so on for the whole list. I've tried several different ways but it cannot be copied and pasted. The formula i was using will not copy down. I'm pretty new to excel ... LOL

 

[Fluff]

How about

=SUMIFS(E:E,B:B,B2,C:C,C2)

 

[kvsrinivasamurthy]

Try. In D2

=MAP(A2:A6,B2:B6,C2:C6,LAMBDA(x,y,z,IF(COUNTIFS(A2:x,x,B2:y,y)=1,SUMIFS(z:C6,x:A6,x,y:B6,y),"")))

 

[nsnodgrass73]

How about

=SUMIFS(E:E,B:B,B2,C:C,C2)

Of course it was something easy LOL Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.