Excel Sum function ignore error

[magicmonk]

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.

---

Comments

[benedict08]

!BEER

Posted using Partiko Android

[steem-ua]

Hi @magicmonk!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 4.313 which ranks you at #1732 across all Steem accounts.
Your rank has dropped 10 places in the last three days (old rank 1722).

In our last Algorithmic Curation Round, consisting of 95 contributions, your post is ranked at #15.

Evaluation of your UA score:

• Some people are already following you, keep going!
• The readers like your work!
• Try to work on user engagement: the more people that interact with you via the comments, the higher your UA score!

Feel free to join our @steem-ua Discord server

[steemitboard]

Congratulations @magicmonk! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You published a post every day of the week

_{You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP}

To support your work, I also upvoted your post!

Do not miss the last post from @steemitboard:

	Downvote challenge - Add up to 3 funny badges to your board
	Use your witness votes and get the Community Badge

Vote for @Steemitboard as a witness to get one more award and increased upvotes!

[beerlover]

^{View or trade BEER.}

Hey @magicmonk, here is a little bit of BEER from @benedict08 for you. Enjoy it!

Learn how to earn FREE BEER each day by staking.

[steemstem]

This post has been voted on by the SteemSTEM curation team and voting trail. It is elligible for support from @curie and @minnowbooster.

If you appreciate the work we are doing, then consider supporting our witness @stem.witness. Additional witness support to the curie witness would be appreciated as well.

For additional information please join us on the SteemSTEM discord and to get to know the rest of the community!

Please consider using the steemstem.io app and/or including @steemstem in the list of beneficiaries of this post. This could yield a stronger support from SteemSTEM.