Nesting SUMIFS in IF
Hello, is it possible to nest a SUMIFS within an IF statement to say If the value of this sumifs is greater zero display the sumifs, but display nothing if the value is not greater than 0?
Best Answer
-
Hahaha nevermind. The answer is yes, and I just had to put the first sumifs within the if statement within parentheses before the greater than zero part
Answers
-
Hahaha nevermind. The answer is yes, and I just had to put the first sumifs within the if statement within parentheses before the greater than zero part
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.5K Get Help
- 448 Global Discussions
- 145 Industry Talk
- 481 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 304 Events
- 37 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!
