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

Hi

Don't delete - use Clear Contents instead

Arvi Laanemets


"vacation" wrote in message
...
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