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.1K Get Help
- 444 Global Discussions
- 141 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 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!
