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")
