How to embed SumProduct in Sumif

[chakroy]

I am trying to allocate costs from an input section to a monthly section. Please see attached.

Rows 1 to 3 are the input section. The fees should be allocated to the 2 different companies and hit the correct month on rows 8-11

[DonkeyOte]

Perhaps you want:

B11:
=SUMPRODUCT(--($B$3:$B$4<=B$10),$D$3:$D$4,INDEX($E$3:$F$4,0,ROWS(B$11:B11)))
copied across matrix B11:M12

(above assumes 100% apportionment in start month irrespective of start day - this is not stipulated as a requirement)

[chakroy]

That works wonderfully! Thank you!