sum data betwen two blank row
 

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

sum data betwen two blank row
 

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

On Nov 27, 7:10*am, eva cheng <eva
wrote:
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 * * * * * *