Hi,

I am a newbie to macros, etc. using the macro recorder where possible.

I have a column of data (Col H) and where a cell is blank, I want to
calculate the sum of the cells since the previous blank. For example,

100
75
100
Blank(Answer here should be 275)
25
0
100
Blank(Answer here should be 125)
100
Blank(Answer here should be 100)
75
50
Blank(Answer here should be 125)

I don't need any grand total.

I am using Excel 2000 with Windows 2000.

Can anyone help?

Kind regards,

Alison