View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sasikiran Sasikiran is offline
external usenet poster
 
Posts: 104
Default Dragging a formula

Dear,

I need to drag the formula in a column in such a way that the formula should
proceed in this manner.

SUM(B14:B18)
SUM(B62:B68)
SUM(B110:B114)

it should calculate the sum range of 4 continuos cells after every 48th
cell...

Hope this is clear

Please suggest