calculate from sheet 1 to sheet 2

[Guest]

I am trying to calculate a set of data from one sheet to another the formula
that i am using dont seem to work =SUM(Daily!C3:C9) when i go to calculate
the next set of data =SUM(Daily!C10:C16) it only seem to bring it dowm one
cell so i end up with a formula =SUM(Daily!C4:C9) any suggestions would be
great thanks

 

[Bryan Hessey]

The natural drag-down formula duplication would give C4:C10 after C3:C9

To add the next 'set', you need to adjust the selection of the range,
if you start on row 9 with your first C3:C9 sum then try

=SUM(INDIRECT("A"&((ROW()-8)*7-4)&":A"&((ROW()-8)*7+2)))

or, to see the effect, in the next column try

=("a"&((ROW()-8)*7-4)&":a"&((ROW()-8)*7+2))

(same formula, without the Sum or Indirect, to test the range to be
accumulated).

If you start your sum on a different row you will need to adjust the
row calculation.

Hope this helps.