Dayle R. answered • 05/16/18
Tutor
4.8
(46)
25 Years of Excel Experience
Use SumIf which allows you to put a condition on which values are summed.
Harris H.
asked • 05/16/18How can I sum only positive values in Excel?
Follow
•
2
Add comment
More
Report
2 Answers By Expert Tutors
Ivan W. answered • 05/16/18
Tutor
5.0
(33)
Excel WHIZ - (guaranteed to help you or your money refunded in full!)
SUMIF
If you type 5 numbers starting from cell A1 to A5, put some positive and some negative, then under it type this formula:
=SUMIF(A1:A5,">0",A1:A5)
THAT will sum your positive values in your range of values.
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
