Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
=SUMIF(A2:A1000,">0")
Sum on only positive numbers in column
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have a long list of numbers and I need to add up only the positive numbers. Some numbers are negative and they should not affect the total sum. I need some kind of formula that says, if the number is positive add it otherwise don't.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
-
Anonymous
2018-02-22T21:35:47+00:00
1 additional answer
Sort by: Most helpful
-
Anonymous
2018-02-22T23:21:33+00:00 Thanks!