I meant to get to this sooner. Sorry for the delay.
You can use this formula in cell B2 of the Winter Instructors tab. Use it to autofill down and across your table.
=SUMIFS(Programs!$I:$I,Programs!$A:$A,">="&VALUE(LEFT('Winter Instructors'!B$1,8)),Programs!$A:$A,"<="&VALUE(RIGHT('Winter Instructors'!B$1,8)),Programs!$E:$E,'Winter Instructors'!$A2)+SUMIFS(Programs!$I:$I,Programs!$A:$A,">="&VALUE(LEFT('Winter Instructors'!B$1,8)),Programs!$A:$A,"<="&VALUE(RIGHT('Winter Instructors'!B$1,8)),Programs!$F:$F,'Winter Instructors'!$A2)
I've also attached a copy with the function already populated across the cells.
Bookmarks