#DIVIDE BY ZERO Error message
The below formula is being used to count items (Installed) & items (Complete) against a cell value (Protection plate) in a sheet summary to produce a %percentage (Complete). The is being used in multiple sheet summaries to compile an overall %percentage (Complete).
The formula works great, however if the column [Protection Plate]1:[Protection Plate] does not have a cell value I am getting a #DIVIDE BY ZERO Error message.
This in turn gives me an Error message on my overall average of %percentage (Complete).
=COUNTIFS([I (4)]1:[I (4)]9, 1, [C (4)]1:[C (4)]9, 1) / COUNT([Protection Plate]1:[Protection Plate]9)
=COUNTIFS([I (2)]:[I (2)], 1, [C (2)]:[C (2)], 1) / COUNT([Lock/Exit Device]:[Lock/Exit Device])
Best Answer
-
Us an IFERROR function to assign a value rather than an error message
IFERROR( Your Formula, value if error )
Answers
-
Us an IFERROR function to assign a value rather than an error message
IFERROR( Your Formula, value if error )
-
I was able to resolve the #DIVIDE BY ZERO Error message by using this formula =IFERROR(COUNTIFS(I:I, 1, C:C, 1) / COUNT(Hinge:Hinge), 0).
However, I am currently hitting a road block on getting an accurate average from my sheet summaries.
Is there a way to get an average in all summaries not labeled OVERALL that will only count averages for summaries greater than 0?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!