How to ignore negative numbers

Hi I have a column of values generated in excel some of which are positive, some of which are negative.

Now these figures can change regularly from positive to negative depending on previous figures entered so what I wanted to create was a cell that only adds up the positive numbers in the column but ignores any negative numbers.

Can anyone help??

Thanks

Assuming values are in A1:A10

Put in say, B1: =SUMPRODUCT(--(A1:A10>0),A1:A10)

Adapt to suit, but note that
we can't use entire col references in SUMPRODUCT
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"frustrated" <[email protected]> wrote
in message news:[email protected]...
>
> Hi I have a column of values generated in excel some of which are
> positive, some of which are negative.
>
> Now these figures can change regularly from positive to negative
> depending on previous figures entered so what I wanted to create was a
> cell that only adds up the positive numbers in the column but ignores
> any negative numbers.
>
> Can anyone help??
>
> Thanks
>
>
> --
> frustrated
> ------------------------------------------------------------------------
> frustrated's Profile:
http://www.excelforum.com/member.php...o&userid=27778
> View this thread: http://www.excelforum.com/showthread...hreadid=472888
>

For entire column references:

=SUMIF(A:A,">0")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Max" <[email protected]> wrote in message
news:e%[email protected]...
Assuming values are in A1:A10

Put in say, B1: =SUMPRODUCT(--(A1:A10>0),A1:A10)

Adapt to suit, but note that
we can't use entire col references in SUMPRODUCT
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"frustrated" <[email protected]> wrote
in message news:[email protected]...
>
> Hi I have a column of values generated in excel some of which are
> positive, some of which are negative.
>
> Now these figures can change regularly from positive to negative
> depending on previous figures entered so what I wanted to create was a
> cell that only adds up the positive numbers in the column but ignores
> any negative numbers.
>
> Can anyone help??
>
> Thanks
>
>
> --
> frustrated
> ------------------------------------------------------------------------
> frustrated's Profile:
http://www.excelforum.com/member.php...o&userid=27778
> View this thread: http://www.excelforum.com/showthread...hreadid=472888
>

"RagDyeR" wrote:
> =SUMIF(A:A,">0")

Much neater to adopt this, without a doubt <g> !
Thanks, RD !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--