Formula to subtotal previous column that dynamically changes so need to find blanks to know which rows to subtotal

[bjurick]

What is the formula that I can use in Column C? I don't want to have to change any cell references as this data changes all the time so it will have to be smart enough to detect blank cells in column B and then place the subtotal in column C. Also, the subtotal in column C is only for a "dynamic" range in between the blank cells in column B. Any help would be greatly appreciated.

A	B	C
Item 1	200.00
Item 2	300.00
Total		500.00
Item 3	100.00
Item 4	500.00
Item 5	400.00
Total		1000.00
Item 6	100.00
Item 7	150.00
Item 8	250.00
Item 9	300.00
Total		800.00

<tbody>
</tbody>

 

[AlphaFrog]

<br />

Book1
	A	B	C
1	Item 1	200
2	Item 2	300
3	Total		500
4
5	Item 3	100
6	Item 4	500
7	Item 5	400
8	Total		1000
9
10	Item 6	100
11	Item 7	150
12	Item 8	250
13	Item 9	300
14	Total		800
15
16
Sheet1

Cell Formulas
Range	Formula
C2	=IF(AND(B1<>"",B2=""),SUM($B$1:B2)-SUM($C$1:C1),"")

Copy the C2 formula down column C

 

[bjurick]

	A	B	C
1	Item 1	200
2	Item 2	300
3	Total		500
4
5	Item 3	100
6	Item 4	500
7	Item 5	400
8	Total		1000
9
10	Item 6	100
11	Item 7	150
12	Item 8	250
13	Item 9	300
14	Total		800
15
16

<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Worksheet Formulas Cell Formula C2 =IF(AND(B1<>"",B2=""),SUM($B$1:B2)-SUM($C$1:C1),"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Copy the C2 formula down column C

Excellent. Thank you so much. Works great!!

Thanks