Originally Posted by

**davsth**
you just need to think how much you need to move for each column, before to move 2 columns you needed to move 3 columns on the other sheet, hence *1.5, this time you need to move 3 columns for every 1 column. The formula are the same with this changes

B5 =SUM(OFFSET('Inndata-Sheet1'!$B5,0,(COLUMN(A1)-1)*3,1,2))

b6 =OFFSET('Inndata-Sheet1'!$D5,0,(COLUMN(A1)-1)*3)

B9 =SUM(OFFSET('Inndata-Sheet1'!$B6,0,(COLUMN(A5)-1)*3,1,2))

B10 =OFFSET('Inndata-Sheet1'!$D6,0,(COLUMN(A5)-1)*3)

its worth your time working out what the formula do

column is just a number A=1 b=2 c=3 etc

offset(starting cell, rows to move, columns to move,height, width)

## Bookmarks