I think I should use absolute values to:

N

N

Copy a sum formula in the below row without affecting the orig value, but
how?? or should I use another function?
 
K

Kassie

If you mean that, should you copy a formula calculating eg the sum of
A10:G10, located in H10, to H11, but you still require the sum of A10:G10,
then yes, you should use =SUM($A$10:$G$10)

--
HTH

Kassie

Replace xxx with hotmail
 
J

Jacob Skaria

Edit the same formula and use function key F4 in each range reference to
change the relative reference to absolute reference. Now copy the formula to
any cell..

If this post helps click Yes
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
Drop down list control value in vba 2
Excel - Wich Function should I use? 1
Dealing with a Pivot Table (when I don't want to) 0
Adding a big matrix in Word 2013 5
SUMIF "value if false" not working 2
Using SUM(INDIRECT()) 2
Sum Values from different column 1

Top