Help with formula to avoid #DIVIDE BYZERO ERROR message

LouSnz

Hello, I have a large formula trying to achieve an AverageIf function - but I still sometimes get the #Divide By Zero error - any ideas of what i can do to the formula to avoid this?

 

=SUMIFS([HEP Time (Minutes)]:[HEP Time (Minutes)], [HEP Name]:[HEP Name], "Galvin Davidson", [Current Month]:[Current Month], 1, Action:Action, "DELIVERY", [HEP Time (Minutes)]:[HEP Time (Minutes)], "<300", [HEP Time (Minutes)]:[HEP Time (Minutes)], ">0") / COUNTIFS([HEP Name]:[HEP Name], "Galvin Davidson", [Current Month]:[Current Month], 1, Action:Action, "DELIVERY", [HEP Time (Minutes)]:[HEP Time (Minutes)], "<300", [HEP Time (Minutes)]:[HEP Time (Minutes)], ">0")

Benjamin Walker

Try wrapping the whole thing in the IFERROR() function

https://help.smartsheet.com/articles/775363-using-formulas#iferror