Glad it worked for you and thanks for the reply.

Basically, the subtotal part returns an array of running sums and associated
max values. The negatives and min function ensure the data is ordered
correctly for the lookup function.

"John Casey" wrote:

This is it. Brilliant, thanks. I have to work through this as I've never used
most of these functions before, but it's extremely elegant and it gives
exactly the result expected. Sl thanks a million, Lori.

"Lori" wrote:

Maybe this filled down from c2 (with d1 as threshold value):

=-LOOKUP(-MIN(D$1,SUM(A$1:A2)),-SUBTOTAL({9,4},
OFFSET(A2,ROW(A$1:A2)-ROW(),{0,1},ROW()-ROW(A$1:A2)+1)))