copying formulas

S

spurge

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

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete a formula but leave the data. 2
Help with copying formula 4
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Formula Auto-Adjustment 1
Sum last 6 2
Formulas 3
average sum of 5rows 3
sumif for a specific number of cells 2

Top