A
Arlen
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.
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.