Sum a Range until a blank Row

Capture.PNGHello, I need a function that will sum a range of cells until a blank row is reached.
Below is an example with the SUM column that I would like to reproduce with a formula.
- the number of columns to be summed never changes
- the number of rows to be summed changes
- the range to be summed is marked by both a text cell containing ":" and is both preceded and followed by a blank row.

I think the formula will need to incorporate the OFFSET and MATCH functions but I am not sure...

I thought I did - sorry. I seem to be having trouble adding the attachment.

Try

=IF(A2<>"",SUM(OFFSET($B2,MATCH("*:*",$A2:A14,0)-1,,MATCH("*:*",$A3:A14,0)-MATCH("*:*",$A2:A14,0),4)),"")

BUT data must have cell with ":" after last data block e.g. "END:"

Fantastic! Thank you

If your problem has been addressed could you please mark thread as solved ("Thread Tools" at top of first post)

and thank for the feedback.