I am trying to find the average of a colum of excluding errors
First time poster long time code borrower and student :)
I am having issues with a formula returning #invalid data type.
I am trying to find the average of the column called "Time to Action," excluding any cells that do not have numbers or contain an error.
I have tried using
=AVERAGEIF([Time to Action]:[Time to Action], ISNUMBER([Time to Action]:[Time to Action]))
I have had no success and can not figure out where I am going wrong.
Any assistance would be appreciated.
Help Article Resources
Check out the Formula Handbook template!