6 replies
by tinyhands88 Accepted solution
by databaseben Accepted solution
try using the methodology of using "range" and "names".
that way you can add and delete items in a named range but the formula referencing the name ranged will stay constant.
by tinyhands88 Accepted solution
by john.a.wills Accepted solution
by rodney.mcmullan Accepted solution
Hi,
simply leave your recipe items, don't delete them.
Have an index column in your spreadsheet runing from 1,2,3 etc... and add new recipe items at the bottom.
If I had sight of your workbook I could better advise but don't delete or move anything on this first sheet would be my recommendation.
Rodney
by al kostiuk Accepted solution
If you select the entire row to delete the linked formulas will automatically adjust to total just the remaining cells. If you insert a row with a list of values the same will apply. So if your total was sum(A1:A8) and you insert a new row at row 7, the formula will extend to include the new row. If you add it below row 8 the formula does not automatically extend the sum range.
Al
This discussion is closed to new replies.
Trending Software posts
Sort by Trending