Thanks for your help! I now have the formula's I need.

"Jerry Derfler" wrote in message
news:eeOld.78347$%x.39424@okepread04...
In Excel I have months and years in column A. (several hundred rows)
In Column B I have data.
I want to sum 12months of data in every 12th cell in Column C.
My forumuls is =sum(B1.B12)
How can I copy this formula down column C so I only have results showing
in every 12th cell and all the 11 cells between each formula is blank.

I prefer a non-macro solution.

Thanks in advance

Jerry




a
a of figures in col. B. I