| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM Fuction
Can I copy and paste a SUM function from one row to another row within a
specific column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Fuction
"Suzan Boyle" wrote:
Can I copy and paste a SUM function from one row to another row within a specific column? What happens when you try it? And how would you like it to behave different? Copy from the Formula Bar into your response. Show us the original formula, the copied formula, and what you want differently. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM Fuction
Yes you can...and how do you want that to behave?
Use absolute referencing if you dont want the cell references to change. Below are the different reference styles. A1 Relative referencing. Both column and row will change if you copy or drag the formula. $A1 The column reference is fixed and will not change A$1 The row reference is fixed and will not change. $A$1 Column and row reference are fixed. -- Jacob "Suzan Boyle" wrote: Can I copy and paste a SUM function from one row to another row within a specific column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need a fuction | Excel Discussion (Misc queries) | |||
| Which fuction! | Excel Worksheet Functions | |||
| IF FUCTION | Excel Worksheet Functions | |||
| need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
| For Each Fuction??? | Excel Discussion (Misc queries) | |||
Hybrid Mode
