ignore negative values when adding

When adding a column containing both negative and positive values, I only
want to add the positive values,and ignore the negative values how do I do
this please?

Hi!

Try this:

=SUMIF(A1:A10,">0")

Biff

"Eqa" <Eqa@discussions.microsoft.com> wrote in message
news:EA0E3E87-AF7E-46B9-A480-806E6D786D0C@microsoft.com...
> When adding a column containing both negative and positive values, I only
> want to add the positive values,and ignore the negative values how do I do
> this please?

I have past and present dates in column A and Dollar values positive and
negative in col B I want to sum Dollar values that are positive only and are
older than todays date. How do I do this pls.

"Biff" wrote:

> Hi!
>
> Try this:
>
> =SUMIF(A1:A10,">0")
>
> Biff
>
> "Eqa" <Eqa@discussions.microsoft.com> wrote in message
> news:EA0E3E87-AF7E-46B9-A480-806E6D786D0C@microsoft.com...
> > When adding a column containing both negative and positive values, I only
> > want to add the positive values,and ignore the negative values how do I do
> > this please?
>
>
>

See response in other thread.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Eqa" <Eqa@discussions.microsoft.com> wrote in message
news:C7520AD1-391A-4244-8C38-379791AD997A@microsoft.com...
> I have past and present dates in column A and Dollar values positive and
> negative in col B I want to sum Dollar values that are positive only and
are
> older than todays date. How do I do this pls.
>
> "Biff" wrote:
>
> > Hi!
> >
> > Try this:
> >
> > =SUMIF(A1:A10,">0")
> >
> > Biff
> >
> > "Eqa" <Eqa@discussions.microsoft.com> wrote in message
> > news:EA0E3E87-AF7E-46B9-A480-806E6D786D0C@microsoft.com...
> > > When adding a column containing both negative and positive values, I
only
> > > want to add the positive values,and ignore the negative values how do
I do
> > > this please?
> >
> >
> >