counting cells between blank cells

[nlmfao]

hi,

I have column A containing values of 1 amongst blank cells and I’m looking for a formula to sum up the cells containing “1” between any given 2 blank cells, displayed in Col B. Does anyone have any suggestions?

Example below;

col A	col B
1
1
1
	3
1
	1
1
1
	2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
	24

<tbody>
</tbody>

 

[bbott]

Welcome to the board.

Enter this in B2 and copy down:

=IF(A2<>"","",SUM($A$1:A1)-SUM($B$1:B1))

 

[nlmfao]

Thank you, much appreciated!!

 

[bbott]

Thank you, much appreciated!!

You're welcome.