Hi

In C3 and copy down use this.

Formula: copy to clipboard
=SUMIF(DATA!$C$3:$C$450,B3,DATA!$D$3:$D$450)


For your other issue, can you explain a little more pls?