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

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" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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" <(E-Mail Removed)> wrote in message
news:e%(E-Mail Removed)...
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" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
--