View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ev Ev is offline
external usenet poster
 
Posts: 5
Default Sum the greatest run of negative numbers

I have a list of returns like that listed below, I want to find out the
greatest continuous run of negative returns,
(i.e. -24-3 =-27, and is greater than -2-4-3-1-1-1=-12) so it would return a
result of -27
6
7
2
0
-2
-4
-3
-1
-1
-1
7
-24
-3
2
4

A function would be the most preferable solution