Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
how do I create a spread sheet to automatically calculate when I | New Users to Excel | |||
calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |