12 rolling months

[pphg]

Guys

Hope you can help me to formulate a formula that will show 12 rolling months based on 2 criteria (month and property).
I have attached the excel file for reference.
Desired output if if I selected a month in 2016. it will show the previous data from the last 12 months.

Appreciate any help. Thank you.

[Sam Capricci]

check this post, it may contain your answer...
http://www.excelforum.com/excel-gene...otal-help.html

[FlameRetired]

I changed the month headers in rows 3 and 12 to make the date matches easier. They are all the first of the month. They are formatted "mmmm" so it looks the same as before.

The formulas are in C3 and filled across.

Please Login or Register  to view this content.

Then in C12 and filled across

Please Login or Register  to view this content.

Then the final formula in C13 filled across is

Please Login or Register  to view this content.

[pphg]

I changed the month headers in rows 3 and 12 to make the date matches easier. They are all the first of the month. They are formatted "mmmm" so it looks the same as before.

The formulas are in C3 and filled across.

Please Login or Register  to view this content.

Then in C12 and filled across

Please Login or Register  to view this content.

Then the final formula in C13 filled across is

Please Login or Register  to view this content.

Thank you for the help! Works perfectly!

[FlameRetired]

Glad to hear it. You are welcome. Thank you for the feedback and the rep.