View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rita Palazzi
 
Posts: n/a
Default Dragging range (array)

How do I copy down a formula where the cell references will increment by
the same amount? E.g. Sum(B100:B104) will increment to Sum(B105:B109)
as opposed to Sum(B101:B105).

Thanks for any help you can provide...

Rita