View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael P. Fleming
 
Posts: n/a
Default Is there a way to autoinsert current row into a formula

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.