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.
Answers
-
You would use an IFERROR statement.
=IFERROR(original_formula, "")
-
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, "")))
-
Try removing the = from immediately before the AVG function and two of the closing parenthesis from the very end to immediately after 2023.
-
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, "")
-
Right. You don't want to REMOVE them completely. You want to MOVE them to immediately after the 2023.
2023)), "")
-
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!