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 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
May 17, 2009 at 09:01 AM
Hi,
You could use SUMIF.
=SUMIF(A1:I1,">0",A1:I1)
Best regard
2
Answer 2 / 2
nilesh
Jun 27, 2010 at 07:32 AM
This is realy a very good solution to the question.
0

Similar discussions

Excel Sum Greater than but Less Than
Ian -
Alli -

4 responses
My lg tv plays negative pictures
Likhwa -
HelpiOS -

1 response
if sum>= 60, color cells red
mindy -
mindy -

4 responses
Reversing background colour and text colouring?
WesternGuy -
WesternGuy -

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

1 response