Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2014-06-24 05:44:48 +0200

ROSt52 gravatar image

When you use the function sum(a5:a7) and add rows into the range between a5 and a7 you always have the new rows included. The function is design for automatically including the new rows.

Depending on where you want to insert your new rows you could add each single cell or one or more ranges to create the sum you finally want to have. This means you can exclude the cells you do not have included in the sum.

Please not that it is not clear why you select the range a4 to a8 and how many rows did you add. Looking at your formulas sum(a5:a8) and sum(a5:a13) you must have added rows after row 5 or before row 7 to get the formula sum(a5:a13)