sum data betwen two blank row

  • Thread starter Thread starter eva cheng
  • Start date Start date
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
 
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
 
Back
Top