Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Help with formula to avoid #DIVIDE BYZERO ERROR message

LouSnz
LouSnz
edited 12/09/19 in Archived 2017 Posts

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

Comments

This discussion has been closed.