IFERROR Function

Bryan Letourneau

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!

Kelly Moore

Hey @Bryan Letourneau

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

Bryan Letourneau

That worked perfectly, thank you so much!

Kelly Moore

Hey @Bryan Letourneau

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

Bryan Letourneau

That worked perfectly, thank you so much!