How to ignore negative numbers

F

frustrated

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
 
R

RagDyeR

For entire column references:

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

--

HTH,

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

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
 
Top