Is there a way to autoinsert current row into a formula

  • Thread starter Michael P. Fleming
  • Start date
M

Michael P. Fleming

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
 
M

Michael P. Fleming

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
 
Top