View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sum variable range of column entries in offset cell

Some thoughts for these lines from your posting ..
Formula in AV943 needs to sum the values in column G starting one row above
Row 943 (in G942) for 6 cells (G937:G942) (answer 18).

Formula in AV942 needs to sum the values in column G starting one row above
Row 942 (in G941) for 6 cells (G936:G941) (answer 19).


Maybe something simple like this using OFFSET would satisfy ..

In AV942: =SUM(OFFSET(G941,,,-6))
This returns the sum of G936:G941, ie 6 cells counting from the OFFSET's
anchor G941 "up" (its "up" because of the negative "-6" used as the height
param).

Copy AV942 down 1 cell to AV943,
which increments the formula to: =SUM(OFFSET(G942,,,-6))
hence returning what you specify above (for AV943),
ie the sum of G937:G942

Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---