Previous Topic Next Topic

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

2 responses

Answer 1 / 2
aquarelle Posts 7435 Status Moderator 491
May 17, 2009 at 09:01 AM
Hi,
You could use SUMIF.
=SUMIF(A1:I1,">0",A1:I1)
Best regard
Answer 2 / 2
nilesh
Jun 27, 2010 at 07:32 AM
This is realy a very good solution to the question.

Similar discussions

c++ program computing sum of squares of two
kajinti -
don -

1 response
Deleting Rows with Negative Numbers
2t -
RWomanizer -

2 responses
Excel Sum Greater than but Less Than
Ian -
Alli -

4 responses
Sum values from one column if another column equals x
Sarah -
vcoolio -

3 responses
Why sum of some numbers is 0
Sonu -
ac3mark -

1 response