Adding numbers of varrying lengths until coming to blank cell

[avolkmar]

I have sets of numbers in column A that I am trying to add together in column B. I want to add the numbers until coming to a blank cell, and then start again with the next group. The final product should look something like the example:

Book1.xlsx

I was hoping to be able to do this with a single formula in column B that I could just drag down to the bottom rather than just summing them individually like I have been. Any help is greatly appreciated!

[alansidman]

Does your actual sheet contain identification data in a column to the left of what is now column A. If so, then you could possibly use a pivot table or the sub totals function. If not then a VBA solution may be the answer. Please provide more information on what your actual file looks like.

[mcmahobt]

Along the lines of what alansidman has suggested, this is a similar thread: http://www.excelforum.com/excel-prog...pty-cells.html

That may be a possibility.

[avolkmar]

Thanks to both of you. I ended up doing something similar to the post mcmahobt suggested. I used the formula:

=SUM(A2:A$1000)-SUM(B2:B$1000)

This worked after pasting it into all of the places I needed totaled.