Looking for a dynamic summing formula

[SteveD]

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

 

[Juan Pablo González]

Function SumStrange(Rng As Range) As Variant
SumStrange = Application.Sum(Range(Rng.Range("A1"), Rng.Range("A1").End(xlUp)))
End Function

I you have in A1:A3, {1;2;3} then you could use this in A4 like

=SumStrange(A3)

for a result of 6

 

[SteveD]

Cool! Thank you very much, this will be a huge time saver!