Using offset to calculate sum of data

[Pinkerton420]

Hi All,

i am trying to create a formula which has 2 criteria and returns the sum of data but using offset.

So For example, look up cells Q7 & F9 from the P&L tab and look up in Data tab, and return me figures from AH to AU but only for those after what's in cell F2. So Cell F2 has Period 12 so I want to return sum of periods 13 and 14 i.e AT and AU. Attached some dummy data to this thread.

I have used offset but it needs to be dynamic so thinking sum product but can't get it to work!

 

[OaklandJim]

Your need is not understandable. The description is not very helpful and the pictures are barely readable.

Might you post a link to a workbook for a helper to work with? You'll get a better response if you do. Put the file on 1 drive, Dropbox, Google Drive etc. Use the link icon above the message area to post a link.