need a sum offset formula to add any three PRECEDING months profit and loss line items where the months are going across the spreadsheet. The adding of which three months depends on the data validation I have used. I put the months starting from March in the source. So if I picked May from the data validation cell, formula should add March,April,and May's line items amounts.
Solved by X. Q. in 19 mins