Try =MIN(A1:A8+A2:A9) which must be entered as an array formula using
SHIFT+CTRL+ENTER rather than just ENTER.
The formula will appear like this in Formula Bar: {=MIN(A1:A8+A2:A9)}
Of course, you can change ranges to fit you need: A1:A99+A2:A100
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Eric" wrote in message
...
I would like to set following conditions in Excel, but find it difficult on
coding.
Could anyone give me any suggestion please?
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
Does anyone have any suggestion?
Thank you in advance
Eric