#divide by zero error with SUMIF


i was hoping someone can help me with this error.

I'm simply trying to sumif a column with quarterly projections , some of which are still $0 as the projections haven't been enterd yet. And instead of the sum summing the 0 cells + the rest of the digits, it's just returning an error.

How can I avoid this? Thanks a lot


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!