Good day,
I seem to be having an issue with what I think should be an easy problem, but for the life of me I cannot find an answer.
I am using Excel 2003.
I have a column. D3-D7 have numbers in them and I want to add them. I put a formula in D8 to SUM all the Cells From D3-D7. No problems there.
When I insert a row above D8 the range for the SUM is not expanding, and if I do put info in the cell a box comes up asking if I want to update the formula.
Is there a way to insert a new row and have it be included in a range?
please let me know if you need clarification.
Thank you
Bookmarks