Embedded Files
Last edit: 2 Sep 2024
Get sum of rows above
Get sum of rows above
If we have to constantly fix the Sum formula as we add more rows above, then we can do this instead:
Get the bottom-most value of a column from another sheet
Get the bottom-most value of a column from another sheet
Usually in accounting, I have to copy the balance in the last row of the current financial year to the start of next year which is in a new sheet. Now I just have to paste this formula in and voila.
Sheet 2024:
Sheet 2023:
Page updated
Google Sites
Report abuse