Offset columns in row formulae

Hi I would be grateful for your help. I have a data sheet with columns of numbers, on a separate tab I want to use index/match to sum a particular number of cells. Rather than changing the column reference manually for each from, is there a formulae that when I copy down the rows it will move across two columns?

Thanks
nick

Hi nickmangan

OFFSET, ROWS maybe! Upload a sample file with some dummy data.