If you insert a row directly above the Excel SUM function, the new row may not be included in the SUM. It may continue to sum cells A1:A4, and ignore A5. To ensure that new rows are included in the total, you can use the OFFSET function with the Excel SUM function.
1. Select cell A5.
2. Enter the following formula:
=SUM(A1:OFFSET(A5,-1,0))
3. Press the Enter key to complete the entry.
4. Insert a row above row 5
5. Type a number in cell A5, and it will be included in the total in cell A6
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment