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.