Sum all above cells until you reach a blank cell

Hello All,

I have values in a column that also contains some blank cells. I would like to sum the values between the blank cells, and put the total in the next column.

Here is what i have:
1
2
3

5
6

4
9
8
3

I would like the sums to appear so there is a 6 in the cell beside the blank after "3". There is an 11 in the cell beside the blank after "6". There is a 24 in the cell beside the blank after "3"

I wrote the following code, but it only gives the cell value of the cell above the blank. I need help fixing this code.

Please Login or Register  to view this content.

Thanks

What is variable FirstColumn? tot? If they are Range variables then here is what I would do:

Please Login or Register  to view this content.

Also I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bug and runtime errors.

You could also do this with the following worksheet formula (in B2 and copied down):

Please Login or Register  to view this content.