How do I add a new row in the Excel table to the bottom of the data

How do I add a new row in the Excel table to the bottom of the data

There is a column of data, such as A2:A11 is some amount of data, in A12 cell to sum up the above data, A12 function formula is: =sum (A2:A11).

However, if you insert several rows above line 12th and then enter data in the newly inserted blank cell, the original function formula =sum (A2:A11) does not change, so the newly entered data cannot be summed. Take a look at the screenshot below:

If you want to dynamically summarize the above data, even if the cell next to the sum is inserted in a blank row, the following function formula is recommended, and the A12 cell is entered as follows:

=sum ($A $2:indirect ("R[-1]c", 0))

Where, INDIRECT ("R[-1]c", 0) is an indirect reference function. The indirect function has two forms of reference, one is the A1 reference form, the other is the R1C1 reference form. Here is the form of R1C1, the indirect function of the 2nd parameter is 0 o'clock on behalf of the R1c1;indirect function of the 1th parameter is "R[-1]c", where R is the row, C represents the column, [1] for the previous line, "R[-1]c" as a whole refers to the previous business front.