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.

How do I select a range?
 

=SUMIF(d:d,"0",d:d)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dan" wrote in message
...
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.

How do I select a range?
 

Hi,

You can use

=SUMIF(D:D,"0")


And as you can see the sum of all negative numbers would be
=SUMIF(D:D,"<0")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dan" wrote:

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.