sum data betwen two blank row

E

eva cheng

I have a file like below
sub-total
jan 10
20 30 <== how to creat a formula to sum data between
blank row ?
feb 30
10
10 50
 
P

Pete_UK

Assuming your data starts on row 2, allowing for headers, put this in
C2:

=IF(AND(B3="",B2<>""),SUM(B$2:B2)-SUM(C$1:C1),"")

and copy down as far as needed.

Hope this helps.

Pete
 
Top