I have the following data set:
and I have the following table:
what I would like to do is create an array formula in the table that would remove the need for many sumifs formulas (such as =SUMIFS(D$10:D$18,$A$10:$A$18,$A3,$B$10:$B$18,”y”,$C$10:$C$18,”y”)) that would need to be dragged across and down so that we would end up with this: