"Eric" wrote:
Under A Colume, there are a list of numbers
Profit
100
101
-50
-60
50
-50
-20
-10
80
Under Colume B, I would like to determine the maximum
consecutive loss from Colume A, in this case, it should
return -50-60 = -110

Clarification needed ....

For the 3 rows starting in the 4th row from the end, do
you want -50-20-10 = -80? And you would want that
to be the "maximum consecutive loss" if -60 were -20
in the 4th row (so that -50-20 = -70, not -110), right?

In other words, you are not just interested in pairwise
"consecutive" losses, but consecutive loss sequences of
any length. Is that right?