I am looking for a formula that I can put in a cell such that it will sum each cell above it until it hits an empty cell. However, I am never sure how many numbers there will be in the column or where in the sheet the formula will be placed.
I think I’m looking for something like: sum(z:a), where z is the cell immediately above the formula and cell a is last cell going up before a blank cell. Can anyone help me out with how to code this?
Thanks for your time and effort,
Steve
I think I’m looking for something like: sum(z:a), where z is the cell immediately above the formula and cell a is last cell going up before a blank cell. Can anyone help me out with how to code this?
Thanks for your time and effort,
Steve