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.

Looking For More?


Silicon Valley Accounting Solutions produces the Solution of the Week in order to share tips and shortcuts that promote process efficiency and highlight software features that may not be in your current toolbox. Please let us know if you have questions on how to accomplish a particular task or if you simply have a comment to share.

Even if you find that you know most of what you see here, it only takes one “Aha” to make regular visits worthwhile. To avoid missing any solutions, you may subscribe and have a new one delivered to your inbox each week.

Contact Us

We want to help you grow
your business, call us
at: (408) 260-5250 or
find out more here.


When you need:
  • Clear processes for cash controls
  • Analysis of results
  • Customized reporting


When you need:
  • Timely and accurate bookkeeping
  • Reconciliations and monthly closes
  • Familiarity with popular accounting software
Web Analytics