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

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.