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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives