ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   copying formulas (https://www.excelbanter.com/new-users-excel/214778-copying-formulas.html)

spurge

copying formulas
 
how do I copy a formula in a column through 52 rows?
I have a column of 52 rows into which I want a sum from about 10 other
column's cells to appear. How do I copy this formula to keep the sum from
the same 10 columns following down with appropriate row #s throughout the 52
rows?

Shane Devenshire

copying formulas
 
Hi,

Show us your formula and an example of the data layout. Because normally
you would just choose Copy and Paste or use the Fill Handle.

Cheers,
Shane Devenshire

"spurge" wrote in message
...
how do I copy a formula in a column through 52 rows?
I have a column of 52 rows into which I want a sum from about 10 other
column's cells to appear. How do I copy this formula to keep the sum from
the same 10 columns following down with appropriate row #s throughout the
52
rows?




All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com