# Excell formula

[DELETED] 19:58 31 Oct 2003
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

[DELETED] 20:18 31 Oct 2003

You could try

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

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

[DELETED] 20:31 31 Oct 2003

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 2003

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.

Elsewhere on IDG sites

Best computer security tips

This fantastic short film is packed with hidden TV and film references

Best external graphics cards (eGPUs) for Mac

Test : les écouteurs Bluetooth Soundcore Spirit X d’Anker