Using Sumifs To Check Multiple Criteria On The Same Column

[Excel Fox]

That's because your aggregation is happening on all of your item_list. That's not what we want, right. So you'll need to pass only those criteria that you specifically need, ie, the individual item.

Here's how you do it

D4=SUM(SUMIFS(Quantity,Item,$C4,Sold_Bought,D$3,mo nth,$B$1,Char,INDIRECT($B$2))) as array formula

or

D4=SUMPRODUCT(SUMIFS(Quantity,Item,$C4,Sold_Bought ,D$3,month,$B$1,Char,INDIRECT($B$2))) as regular formula

drag this down and across and you should see results