ytd comparison P&L till a particular month

[sureshsonti]

Hello,
I am trying to create a formula where I can compare YTD (year to date) values for 2018 and 2017 in a P&L format.

I have 2017 and 2018 Sales data in gl_data tab

In the PL tab I have created my Revenues for 2018 each month. At the end I have YTD for 2018. After that I want to show Year To Date for 2017 Revenues as of August 2017 because for 2018 I have my Revenues till August 2018.

So basically I want to compare Revenues for 2018 and 2017 till August for both years

I have attached the desired result.

Thanks for all your help

 

[Nebu]

Hi:

Formulas in yellow cells.

Thanks

 

[sureshsonti]

Hi:

Formulas in yellow cells.

Thanks

Thanks Nebu. I have been trying this the whole day. I tried this forumla and was getting #VALUE! error. Again thanks for your help.

SUMPRODUCT((heckyardage[YEAR]=$AS$7)*(heckyardage[MONTH] >= AS11) * (heckyardage[MONTH]<= AT11)*(heckyardage[[#Headers],[CO 1]:[CO 4]]=PL!AS4), heckyardage[[CO 1]:[CO 4]])