Sumproduct with two criteria over multiple sheets - formula error

**nickmax1** · 03-26-2013, 12:32 PM

Why does this formula not work????

=SUMPRODUCT(SUMIFS(INDIRECT("'"&tabs&"'!E18:E190"),$H10,INDIRECT("'"&tabs&"'!B18:B190"),$H11,INDIRECT("'"&tabs&"'!g18:g190")))

Get a value error.

As a reference, my formula:
=SUMPRODUCT(SUMIF(INDIRECT("'"&tabs&"'!E18:E190"),$H10,INDIRECT("'"&tabs&"'!g18:g190")))

works fine. I just need another condition (hence my use of SUMIFS) .

**Jonmo1** · 03-26-2013, 12:38 PM

In SUMIF the SumRange comes last
=SUMIF(Range,Criteria,SUMRange)

BUT, in SUMIFS, the SumRange comes FIRST
=SUMIFS(SUMRange,Range1,Criteria1,Range2,Criteria2)