How Do I Remove #DIVIDE BY ZERO from Calculation in Sheet Summary?

Looking for a way to remove #DIVIDE BY ZERO in sheet summary calculation when there is no data.

Goal is to calculate average # of Workdays from Receipt to Fully Executed in a specific month, in this case, June 2023.

Some months I will not have any data and the example below is such a case. See attached images.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!