Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions |