Thread: How do I select a range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
  
Posts: 866
Default How do I select a range?
I have a function which generates monotonic series. The numbers in column D
start positive and at some point go from positive to negative. I use
=MATCH(0,D:D,-1)to find the row number which holds the first negative number.
I want to find the sum of all positive numbers. How do I do that? Any help is
appreciated.
Reply With QuoteReply With Quote