Indirect Sumifs with Or Criteria

Originally Posted by daffodil11

You can accomplish OR logic within a SUMIFS function, but the criteria has to be explicitly declared.

=SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheet&"'!E:E"),INDIRECT("'"&Sheet&"'!B:B"),{"SUB.2","SUB.3"}))

You can put the criteria in a horizontal range of cells.

=SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!B:B"),B2:C2,INDIRECT("'"&Sheets&"'!E:E")))