Is there a way to autoinsert current row into a formula

G

Guest

I'm working on a large inventory list that has a qty and price column. I want
to add another column to sum those two fields. I would like to avoid manually
doing each row and would like to "autoinsert" the current row number into the
formula so I would only have to define the column. If I can automatically
insert the row number into the formula I can copy the same formula to each
row and get my totals.
 
P

Peo Sjoblom

What happens when you copy the formula? If you copy a formula down and use
relative cell references it will
increase the row number as in

=A2+C2

copied down a row will be

=A3+C3

?

--
Regards,

Peo Sjoblom

Portland, Oregon
 
G

Guest

When I copy the formula it still is adding d2*e2. How do i start relative
cell references? Im using XP Excel.
 
P

Peo Sjoblom

Look under tools>options>calculation and set calculation to automatic
now copy down (to copy down drag the lower right corner of the cell with the
mouse)

--
Regards,

Peo Sjoblom

Portland, Oregon
 

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

Is there any way to auto-insert a row? 4
What is the "--" (double dash) in MS Excel formula? 2
Excel Help to copy information from one row at a time to another sheet 1
using row number or column letters in formula 5
Add/Subtract columns from tab to tab in same file 3
Sum Column above current cell dynamically using function call 7
Formula adjust for inserted row above current row 8
Is there a way to change the color 3

Top