At sum / less negative numbers

Solved/Closed
wasakidonce - May 16, 2009 at 12:38 PM
 nilesh - Jun 27, 2010 at 07:32 AM
Hello,
Hi, I need to at sum a list of number but not the negative numbers. How do I write the formula? I’m 70 years old and kind of new at this but I keep learning.
Thanks wasakidonce

A 50
B 25
C 50
D 50
E –10
F 50
G 50
H –25
I 50
=====
J at sum
Related:

2 responses

aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
May 17, 2009 at 09:01 AM
Hi,
You could use SUMIF.
=SUMIF(A1:I1,">0",A1:I1)
Best regard
2
This is realy a very good solution to the question.
0