Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 14th 04, 07:20 PM
Jerry Derfler
 
Posts: n/a
Default 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



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


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

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

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


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

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.

Thanks in advance

Jerry




a
a of figures in col. B. I





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 12th 05 11:55 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
Copy Formula But Keep 1 Common Cell Towmech Excel Discussion (Misc queries) 3 December 18th 04 12:09 AM
Cell contents vs. Formula contents Sarah Excel Discussion (Misc queries) 3 December 15th 04 06:02 PM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 04:30 AM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017