Hi Robert,
To sum all rows above a specific cell without specifying specific rows, you can use the
SUM function with a cell range that starts from the first cell in the column and ends at the cell just above the cell where you want to display the total.
Here are the steps to do this:
- Select the cell where you want to display the total.
- Type the following formula:
Code:
=SUM(A1:A"current row number"-1)
, where "current row number" is the row number of the cell where you want to display the total.
For example, if you want to display the total in cell C5, the formula would be .
- Press Enter to calculate the total.
Now, the cell will display the total of all the numbers above it in that column. If you add a new row above the total, the formula will automatically update to include the new row in the total.