| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas
Hi all,
I have a row of forumulas, which relate to columns of data. Each formula needs to be copied down the sheet, but I need the column value to change, not the row value. eg C3 : =sum(c2:c31) C4 : =sum(d2:d31) C5: =sum(e2:e31) etc. How can I replicate the formulas down, but get the Column values to change ? TIA Stu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Error when copying formulas | Excel Worksheet Functions | |||
| excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
| Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
| Copying options: contents, results, formulas, etc. | New Users to Excel | |||
| Excel & Copying Formulas | Excel Worksheet Functions | |||
Threaded Mode
