Calculating Column Average in Sheet Summary

shelbylund

Hello,

I'm trying to calculate the average of the column "Days to Creation" in my Sheet Summary. I need the formula to ignore blank cells and any that contain #INVALID ERROR TYPE.

Does anyone have suggestions on how to modify my formula?

Paul Newcome

You would need to put the IFERROR in the [Days To Creation] column formula to remove the errors from the source data.

Paul Newcome

It would look something like this:

=IFERROR(NETWORKDAYS(………………), "")

Paul Newcome

You would need to put the IFERROR in the [Days To Creation] column formula to remove the errors from the source data.

shelbylund

Hi @Paul Newcome,

Here is the formula that is in my [Days to Creation (Helper)] column. Do I add IFERROR to the beginning of this? Is there anythig else I need to add?

Paul Newcome

It would look something like this:

=IFERROR(NETWORKDAYS(………………), "")

shelbylund

Thank you so much!

Paul Newcome

Happy to help. 👍️