Remember Me?

#1
November 14th 04, 07:20 PM
 Jerry Derfler Posts: n/a
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.

Jerry

a
a of figures in col. B. I

#2
November 14th 04, 07:53 PM
 Domenic Posts: n/a

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.

Jerry

a
a of figures in col. B. I

--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785

#3
November 14th 04, 07:59 PM
 Frank Kabel Posts: n/a

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.

Jerry

a
a of figures in col. B. I

#4
November 14th 04, 11:09 PM
 Jerry Derfler Posts: n/a

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

"Jerry Derfler" wrote in message
news:eeOld.78347\$%[email protected]
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.

Jerry

a
a of figures in col. B. I

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jason30 Excel Discussion (Misc queries) 1 January 12th 05 11:55 PM [email protected] New Users to Excel 2 January 6th 05 07:18 AM Towmech Excel Discussion (Misc queries) 3 December 18th 04 12:09 AM Sarah Excel Discussion (Misc queries) 3 December 15th 04 06:02 PM KC Mao Excel Discussion (Misc queries) 2 December 4th 04 04:30 AM

All times are GMT +1. The time now is 03:44 AM.