Need Help w/ Sumif Type Function - Recurring Values in Column and Row Criteria

[bluefingerblue]

Hi all - need some help with a function that is effectively a sumifs with recurring column and row criteria. See the attachment. The cells highlighted yellow are the cells I need to solve for.

Thanks.

[Ace_XL]

In Cell B12

=SUMPRODUCT(($A$3:$A$9=$A12)*($B$2:$I$2=B$11)*($B$3:$I$9))

Copy down and across

[Sam Capricci]

try this in cell B12 =SUMPRODUCT(($B$2:$I$2=B$11)*($A$3:$A$9=$A12),$B$3:$I$9)
then drag toward right and down.

[bluefingerblue]

Excellent. Much appreciated. I already tried the response above yours - it works on the example I gave but from some reason didn't work on the actual data set. Yours was perfect. Thanks.

Would it be easy to explain what's happening in that function? Using a sumproduct here doesn't intuitively make sense to me, although I was trying it based on a quick google search.

[Sam Capricci]

it works like it is setting up a table, looking across the top - row 2, for all matches of what is in either cell B11 or C11, the next section looks down column A for a match for the items in A12, A13 or A14 and since there are multiples it is aggregating them, the last part is taking the data in B3 through I9 and summing all the cells that match 2015 and product sales for example.
I tend to use it a lot for structures like the one you posted.

[bluefingerblue]

I was actually confused about the asterisk in the first clause of the function. Didnt realize the asterisk is the AND operator in sumproduct functions. Makes sense now. Thanks