SUM Fuction

S

Suzan Boyle

Can I copy and paste a SUM function from one row to another row within a
specific column?
 
J

Joe User

Suzan Boyle said:
Can I copy and paste a SUM function from one
row to another row within a specific column?
Click to expand...

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.
 
J

Jacob Skaria

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.
 

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

Multiple IF Statement in Word 5
Need Help with a VBA subroutine 0
SUMIF between date range 0
Copy addition formula of non-consecutive horizontal cells 2
Dealing with a Pivot Table (when I don't want to) 0
Adding a big matrix in Word 2013 5
sqlite-odbc write conflict 2
Sum Values from different column 1

Top