IFERROR Function
Hi Community,
I'm having an issue incorporating an IFERROR function into my existing function which identifies the average of averages greater than 0. However, the formula runs into the divide by zero error which I hope to default to 0% in event of the error.
Please see formula below where I need to incorporate the IFERROR function
Any help would be greatly appreciated.
Thanks!
Best Answers
-
I wondered what you had tried that isn't working. Here's my suggestion. I usually try my calculations first without the SUM
=IFERROR(May1:May7/(COUNT(May1:May7)-COUNTIFS(May1:May7, 0)),0)
Does this work for you?
Kelly
-
That worked perfectly, thank you so much!
Answers
-
I wondered what you had tried that isn't working. Here's my suggestion. I usually try my calculations first without the SUM
=IFERROR(May1:May7/(COUNT(May1:May7)-COUNTIFS(May1:May7, 0)),0)
Does this work for you?
Kelly
-
That worked perfectly, thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives