Nesting SUMIFS in IF
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!