adding columns by formula

[Rivers]

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

 

[Dave Peterson]

I would add a row to the detail sheet that was for headers.

In the Week column, I'd put Week.

Then I could use:

=sumif(backsheet!$1:$1,"week",backsheet!7:7)

You could hide this row if it didn't look nice.

And if you used headers like: Week 1, Week 2, ....
Your formula could change to:
=sumif(backsheet!$1:$1,"week*",backsheet!7:7)