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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
Running total by date 2
insert row when sum of values equals 100 3
YTD budget based on current input of actual 4
adding hours and minutes 7
using sumifs with multiple criteria? 3
Insert a Row and then Sum 1
Excel Help with dates 2

Top