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