Projecting revenue in month based on date. Also total if/then stuff.

Thanks! Almost there, I think.

That totally clears up the second part of the ask!

On the month 1-3 though... only one column should populate in each row. P should populate if F(any) and D(3) are in the same month. Q should populate if F = current month + 1(. Month 3 should populate if F = Current month + 2(months).

If I populate all the cells P-R with: =IF(DATE(YEAR($F5),MONTH($F5),DAY(1))=DATE(YEAR($D$3),MONTH($D$3)+COLUMN(A1)-1,MONTH(1)),$K5,"")

All the cells populate with the same value.

The only change you should need to make is for S5: =sumif(P5:R5,">0"), and then copy that formula down to S12.