Hello,
Im using the formula below to sum multiple sheets that has a code in cell
D1. I would like to modify if possible to accommodate one more criteria in
cell F1 of the summary sheet. The references for E:E and B:B should remain
the same.

I obtained this formula awhile back using this forum.

Thank you.

=SUMIF(INDIRECT("'"&A2&"'!E:E"),summary!$D$1,INDIR ECT("'"&A2&"'!B:B"))