Copy formula to every 12th cell
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 |
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 |
Hi
for a non macro solution try the following formula in C12 (and copy it down afterwards) =IF(MOD(ROW(),12)=0,SUM(OFFSET(B12,0,0,-12)),"") -- Regards Frank Kabel Frankfurt, Germany 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 |
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 |
All times are GMT +1. The time now is 06:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com