Good evening,
(was originally posted to Microsoft Answers, but was told it's an engineering questions, and should be posted here)
I am using the following formula on Tab01, Cell E5:
=SUMPRODUCT(SUMIF('Rolling Average Usages'!$F:$F,K5:L5,'Rolling Average Usages'!$L:$L))
*this formula returns the sum of all matches from the list in K5:L5. The math returns 12373 (which is correct).

I would like to add the variable to include the value in cell B5 so that it returns just the values that correspond to it. the Tab02 picture shows the values, and the desired result should be 619+350=969.

Help to add one more criteria would be appreciated. I can use sum(sumif1+sumif2+sumif3...), but that formula starts to grow pretty fast, so am looking to keep the formula smaller.
thank you.
K.