#divide by zero error with SUMIF

milena85

Hello,

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

Ayelet Weiner

Hi,

You'll want to wrap your formula with the IFERROR Function.

https://help.smartsheet.com/function/iferror

If you post your current formula, I can assist you with adding IFERROR to your formula. Hope that helps!