Formula on how to get the sum of specific criteria

[ALLANT]

Hi team,

Please help me to provide correct formula on my spreadsheet. I have attached sample data sheet.

[alansidman]

Excel 2016 (Windows) 32 bit

	B	C	D
15	Remarks	Qty.	Value
16	On hand	=SUMIFS($B$4:$B$11,$D$4:$D$11,B16)	=SUMIFS($C$4:$C$11,$D$4:$D$11,B16)
17	Scrapped	=SUMIFS($B$4:$B$11,$D$4:$D$11,B17)	=SUMIFS($C$4:$C$11,$D$4:$D$11,B17)
18	Shipped	=SUMIFS($B$4:$B$11,$D$4:$D$11,B18)	=SUMIFS($C$4:$C$11,$D$4:$D$11,B18)

Sheet: Sheet1