Excel: Protect Sum Formulas
Ever wasted time trying to determine why your SUM formula isn’t correctly adding up all of your cells like you intended? Here is a fool-proof way to protect your SUM formulas from losing their integrity when adding or moving rows or columns.
Always include a blank row or blank column at both the beginning and the end of your data range. Your SUM formula range should include rows and columns up through the blank row and column.
Each time you add data rows or columns to your worksheet, be sure to insert them within the range of the blank row or column and your SUM formula will automatically include the new data.