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

Joan156

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.

Paul Newcome

You would use an IFERROR statement.

=IFERROR(original_formula, "")

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

Joan156

@Paul Newcome

Unfortunately I'm receiving an #INCORRECT ARGUMENT SET message.

What am I doing wrong?

=IFERROR(=AVG(COLLECT([# Workdays from Receipt to Fully Executed]:[# Workdays from Receipt to Fully Executed], [Contract Type]:[Contract Type], "MSA (Master Services Agreement)", [Today's Date]:[Today's Date], MONTH(@cell) = 6, [Today's Date]:[Today's Date], YEAR(@cell) = 2023, "")))

Paul Newcome

Try removing the = from immediately before the AVG function and two of the closing parenthesis from the very end to immediately after 2023.

Joan156

@Paul Newcome

I removed the = and last two parentheses but the cell auto-fills the other two parens. When I select enter I receive the same #INCORRECT ARGUMENT SET message.

=IFERROR(AVG(COLLECT([# Workdays from Receipt to Fully Executed]:[# Workdays from Receipt to Fully Executed], [Contract Type]:[Contract Type], "MSA (Master Services Agreement)", [Today's Date]:[Today's Date], MONTH(@cell) = 6, [Today's Date]:[Today's Date], YEAR(@cell) = 2023, "")

Paul Newcome

Right. You don't want to REMOVE them completely. You want to MOVE them to immediately after the 2023.

2023)), "")

Joan156

WOO HOO!

It works.

Thank you, @Paul Newcome

Paul Newcome

Happy to help. 👍️