[dan]

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.

[Don Guillett]

=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.

[Shane Devenshire[_2_]]

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.