variable criteria in sumif formula

I have the following formula in cell D2: =SUMIF('115281'!$A$4:$A$50,D$2,'115281'!$D$4:$D$50). I'm curious if there is a way for the formula
to pull the '115281' from cell B2. Please see attached file.

Thanks

Sure, you do it like this:

=SUMIF(INDIRECT("'"&B2&"'!$A$4:$A$50"),D$2,INDIRECT("'"&B2&"'!$D$4:$D$50"))

Strictly speaking, you don't need the $ symbols for the ranges as they are now text values, and so won't change if you copy the formula elsewhere.

Hope this helps.

Pete

Pete,
That works perfectly. Thanks so much!!
Dave