At sum / less negative numbers

[Solved/Closed]
Report
-
 nilesh -
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 replies

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
488
Hi,
You could use SUMIF.
=SUMIF(A1:I1,">0",A1:I1)
Best regard
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

This is realy a very good solution to the question.