Excel Sum of from a cell to the RowAbove, or the next row above
I got the idea and concept here: Three Ways to Reduce Errors In Your Excel SUM Formulas
Essentially; what I wanted to do was prevent the Insert Row just above the total line to always include the row above. So after playing a bit I found the site above.
So here is the process: In the workbook you want to have the sum click on any cellDepending on the version of Excel find where you name a range, for 2007 Formulas, Define NameA new name dialog box is displayedMake Name "RowAbove"Scope: WorkbookAdd a comment the next row upDelete the sheet name and enter in the row aboves address, in my case I clicked on =MySheet!$B$4, so I replace that with "=!B3"Then anywhere I want to add a sum or subtotal I just use sum(A3:RowAbove), then that will sum from A3 to the row above
Now even if a insert row above on the formula it will add it the value to the sum.
I got the idea and concept here: Three Ways to Reduce Errors In Your Excel SUM Formulas
Essentially; what I wanted to do was prevent the Insert Row just above the total line to always include the row above. So after playing a bit I found the site above.
So here is the process: In the workbook you want to have the sum click on any cellDepending on the version of Excel find where you name a range, for 2007 Formulas, Define NameA new name dialog box is displayedMake Name "RowAbove"Scope: WorkbookAdd a comment the next row upDelete the sheet name and enter in the row aboves address, in my case I clicked on =MySheet!$B$4, so I replace that with "=!B3"Then anywhere I want to add a sum or subtotal I just use sum(A3:RowAbove), then that will sum from A3 to the row above
Now even if a insert row above on the formula it will add it the value to the sum.