Calculating similar information/values as per two different dates

Hi John,
I was busy with some other stuff last few days.

The above solution worked for me very well.
However, some times "summarized data" cannot be seen on the "Monthly Advanced Production Summary". I noticed this happened when I added rows to the "Monthly Advanced Production Summary" sheet.

Anyway, today I did some changes in the other sheets in this excel work sheet(it has some more sheet tabs, and I deleted them to reduce the size), the data on the "Monthly Advanced Production Summary" disappeared.


Attached the error sheet for your reference.

Regards
Anuruddha