View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Morgan Morgan is offline
external usenet poster
 
Posts: 39
Default count current run of positive numbers

hi, in Column M i have a list of results that will go on down the page as
values are entered elsewhere, these results will be both negative and
positive, i was after a formula that will give me the count of the current
run of positive numbers, eg. below, the cell with the formula in it would
return a value of 4 for the current run of positive numbers, and if there was
a run of negative numbers it would be 0

2
5
6
-5
2
4
7
9
--
thanks