SUM the cells between two cells with zeros (from formula) in a column, multiple occurances

I have a column of numbers (results from formulae) for which I would like to return SUMs for the values between randomly spaced zero values.
If this is not possible, I could have null values (#VALUE!) rather than zeroes. (But I'd like to hide any #VALUE! from displaying/printing)

This is very similar to the thread: Macro to SUM the cells between two blank cells in a column, multiple occurances

link: http://www.excelforum.com/excel-prog...ccurances.html

example:

100
23
2 125
0
47
52 99
0
2347.5
28 2375.5
0

Thanks!