SUMIF
Musa
✭
Hi all,
I am trying to add a range of cells on condition that it does not contain any value that is equal to/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135.
anyone to help?
Comments

Musa,
I think I've got a solution for you that you'll want to experiment with. In this example the Sum of the numbers is in Column 1 and the other 5 numbers are in columns 2 through 6 respectively.
=IF(AND([Column2]1 > 0, [Column3]1 > 0, [Column4]1 > 0, [Column5]1 > 0, [Column6]1 > 0), SUM([Column2]1:[Column6]1), 0)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 324 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!