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.

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




"Michael P. Fleming" <Michael P. wrote in
message ...
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.

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

"Peo Sjoblom" wrote:

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




"Michael P. Fleming" <Michael P. wrote in
message ...
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.

Look under toolsoptionscalculation 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




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

"Peo Sjoblom" wrote:

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




"Michael P. Fleming" <Michael P. wrote
in
message ...
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.