Help YTD and YTG Automatique Formula

[PMI1980]

Every Month i run a report that contains 12 columns for Example in September i would have 9 months YTD actuals and 3 months YTG rolling forecast, in October i will have 10 months actuals YTD and 2 months YTG.

Can you give me a formula that will recongnize which period are we and calculate automatically YTD in one colum and the YTG in another column.

Thank you.

 

[PMI1980]

OUPSSSS... Im fin e with YTD but how can i calculate the YTG automatically i don't want to make SUM total year - YTD, cause my formula is much more complicated than that i tried to put => instead of <= but it not working...

 

[Robert Mika]

OUPSSSS... Im fin e with YTD but how can i calculate the YTG automatically i don't want to make SUM total year - YTD, cause my formula is much more complicated than that i tried to put => instead of <= but it not working...

Can you explain that a little bit better?
Which formula is more complicated?
And whre did you use the => and <= signs?

 

[PMI1980]

Yes,

The formula for the YTD is working perfectly. Now how can i have formula that will now which period we are and sum automatically the remaining months, in other words i'm looking for the equivalent formula that you gave me but to retrieve the YTG.

Thank you

 

[Robert Mika]

=SUMIF($A$2:$L$2,">"&M$1,$A3:$L3)

In N3

 

[PMI1980]

I LOVE YOU my dear MIKA, THANK YOU