How to ignore error msgs when calculating the average?

SIS

I'm trying to calculate the average of the "planning notified -QSTO generation" column and ignore the invalid data type. I've tried the attached averageif formula but it seems to be not working! getting invalid data type.

Highly appreciate your help!

Thanks

=)

Andrée Starå

Hi @SIS

I hope you're well and safe!

You can add an IFERROR function at the start of the formula.

https://help.smartsheet.com/function/iferror

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SIS

Hi Andree, Thanks for your input. I am actually stuck at if I add iferror what would be the value_if_error?

I just want to ignore the #invalid data type cells and calculate the average.

SIS

using isnumber.PNG

I tried isnumber as well, Getting an error!

Andrée Starå

@SIS

Happy to help!

Try this.

=AVERAGEIF([Planning notified - QSTO generation]:[Planning notified - QSTO generation],
 ISNUMBER(@cell))

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!