Need formula to add total cost and total amount

[J2Reed]

Hi, so I am building an excel chart and I've tried a few formulas and I can't figure this one out.

In Cell D3:D6, use a formula that will add up the total costs from TABLE B for the matching code.
In Cell E3:E6, use a formula that will add up the total amounts from TABLE B for the matching code.

Let me know if this sounds confusing. Attached is TABLE A and TABLE B.

 

[J2Reed]

I'm using the SWITCH formula for C10:C16 if that matters.

 

[J2Reed]

Never mind I figured it out.

=SUMIF($B$10:$B$16,B3,$D$10:$D$16), drag down

=SUMIF($B$10:$B$16,B3,$E$10:$E$16), drag down