calculate from sheet 1 to sheet 2
 

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

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.



kriss_01 Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=475328