| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Copy Formula But Keep 1 Common Cell | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
Threaded Mode
