View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vacation
 
Posts: n/a
Default Keep formual intact after deleting a line

My formula reads =sum(a5+f5+g5+l5)*0.75. This represents items I want to tax
out of a larger range of items. I want to be able to delete one or more of
those lines (like af and g5) and still have the formula produce a result, not
REF! Is this possible?
Thank you