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