Sum value in a column based on condition

[Weasley0307]

Hi, I have a userform to trace the number of wooden pallet and wooden case that my company receive from and return to the vendor. I want to code the function that can automatically sum the quantity in column D based on 4 different categories as shown in the red circle (which I had manually keyed in).

Anyone can show me how do i code so that vba will know, for example, if we are receiving xx pallet, then it will only sum this category of data at D12? If we are returning back xx case then it will sum it in D16 etc. Thanks

 

[SunnyAlv]

Why don't you use the SUMIFS function?

Cell D12

=SUMIFS($D$3:$D$9,$B$3:$B$9,"Pallet",$C$3:$C$9,"Receive")