Have you tried adding numbers in Excel where one of the numbers is an error? Here is a possible fix.You can also apply this fix with the average function.
Posted from my blog with SteemPress : http://magicmonktutorials.com/blog/2020/03/08/excel-sum-function-ignore-error/
Mathematics & Digital Technologies Education
Videos, quizzes, and other learning resources
Eddie the Magic Monk has 15 years teaching experience as a high school teacher in Australia. He will explain things to you in the simplest way possible to help you fully understand high school mathematics and computer science concepts.
Eddie began his tutorial channel on Youtube in 2012. His videos have been well received all over the world and now has 20+ million views! He sees the benefit in multidisciplinary learning hence his tutorials cover topics ranging from maths to dance.