How to perform the following function in Excel?

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

Hi


=SUMIF(A:A,"<0",A:A)


Arvi Laanemets


"Eric" <Eric@discussions.microsoft.com> wrote in message
news:86CBA03E-68E2-4035-AD89-444227FCFD2E@microsoft.com...
> 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

See answer in MISC newsgroup.
Please do not multipost.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eric" <Eric@discussions.microsoft.com> wrote in message
news:86CBA03E-68E2-4035-AD89-444227FCFD2E@microsoft.com...
>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

Sorry, forget it!