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? |
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