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...