Adding 8 columns by formula
 

hi all is this possible.

i have in the background a spreadsheet that everyweek i add seven columns
and an 8 column that sums the seven days. simple enough! now i have a front
sheet that collates the back sheet by bringing forward the sum columns and
collates them by row ie A6 = backsheet!AB7 A7=backsheet!Aj7

instead of everyweek having to create the equals signs i just want to put in
a formula that simply goes down the rows adding 8 columns to the previous row
for 52 weeks.


something like this =backsheet!column(a3+6)

is this possible? i dont mind adding an extra column in my front row to
hold/store numbers as i think this is whats going to be needed to make this
work.

thanks before hand


Rivers

Adding 8 columns by formula
 

=SUM(OFFSET(backsheet!A3,,,1,8))
--
David Biddulph

"Rivers" wrote in message
...
hi all is this possible.

i have in the background a spreadsheet that everyweek i add seven columns
and an 8 column that sums the seven days. simple enough! now i have a
front
sheet that collates the back sheet by bringing forward the sum columns and
collates them by row ie A6 = backsheet!AB7 A7=backsheet!Aj7

instead of everyweek having to create the equals signs i just want to put
in
a formula that simply goes down the rows adding 8 columns to the previous
row
for 52 weeks.


something like this =backsheet!column(a3+6)

is this possible? i dont mind adding an extra column in my front row to
hold/store numbers as i think this is whats going to be needed to make
this
work.

thanks before hand


Rivers