Referring to "current cell row minus one" in a SUM function
Posted by Fred P on August 16, 2001 12:28 AM
I need to be able to sum a column of values, e.g.,
A11 SUM(A1:A10), however if someone manually inserts
a row at row 11, I want the sum function to take this
new row into account, as in
if I could treat the cell reference as a variable:
Axx SUM(A1:Acurrent_row - 1)
I'd rather not use VBA for something this simple.
this would solve my problem, can this be done?