View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arlen Arlen is offline
external usenet poster
 
Posts: 86
Default A formula that autofills by trend, not linear

I have groups of months on one sheet, and a yearly summary sheet besides.

I need the first yearly formula to sum the range Months!A1:12.
I need the second year to sum the range Months!A13:A24.

As I autofill this formula down, I need the references to jump by 12, but
Excel is only counting up by 1. How do I set Excel straight on this one?

Thank you for your benevolence.