SUMIFS for Date Range

Yes, sorry for the vagueness:
The core of the problem is linking up needed rooms tied to the specific date range:

What I have so far is a way to parse out the amount of rooms being used per building:
=SUMIFS($B$3:$B$12,$C$3:$C$12,E22)
=SUMIFS(# of rooms needed, date range, reference cell)

And a way to determine in a room is being used during that specific date:
=IF(SUMPRODUCT(($D$3:$D$12<=I$20)*($E$3:$E$12>=I$20+1)*($C$3:$C$12=$H21)),1,0)
=If(Sumproduct((Start Date <= Reference date in graph)*(End Date <= Reference date in graph)*(building*reference cell)),1,0)

How can the SUMIFS function be modified to limit the number of rooms returned for only the specified range of dates?

Attached is the predicament: