SUMIFS Not Equal Formula Issue

I'm having an issue with the below SUMIFS function specifically with the not equal to logic. The underlying data column has various values but in some cases it's simply blank. It appears that when the cell is blank, it's not including it in the SUMIFS. Is there a work around or change to the logic to include those values? Thanks.


=SUMIFS({Points}, {Epic}, [Epic]1, {Resolution}, <>"Won't Do")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!