Excell formula

  jakester 19:58 31 Oct 03
Locked

how can I get excell to only show a positive result to a formula, I could do it in Lotus 123 with SUMPOSITIVE but can't find an equivalent in excell, any suggestions

  Worm of Doom 20:18 31 Oct 03

You could try

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

where A1:A10 is the range of values you want to add.

  cdb 20:31 31 Oct 03

Just had a flash back from my sinclair spectrum days and tried =ABS(-10) and it gives the result 10 so try =ABS(your formula). I think back in the good old days it meant absolute value ie ignores the + and - or something.

  james55 23:37 31 Oct 03

As Worm of Doom I would agree, but this formula would return an empty cell rather than 0.

=IF(SUM(A1:A10)>0,SUM(A1:A10),"")

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now