C1, copied down:
=IF(TEXT(A1,"mmm")="Dec",SUM(OFFSET(B1,,,-12)),"")
Hope this helps!
Jerry Derfler Wrote:
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
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=278140