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

Hi!

I have manually put numbers in P5 through R12 for the sake of illustration. I want P5 to have the value of K5 when F5 is the same month as D3. I want Q6 to have the same value as K6 when F6 is the month after D3. I need the others to be "zero" for the sake of summing the columns.

Also, I want totals in U and V to be if/then totals. The totals are the same as K however U5 would not populate here because there are numbers in I5 and or J5. V7 would not populate because there are no values input in I7 or J7.


Pipeline.xlsx