How to average with errors in excel

[@ad686]

Thank you so much for sharing your skills and knowledge!

[@j.sineduce6163]

You the Woah’man! I’ve entered a lot of different formulas prior to this and none of them worked ALSO none of them said to press ctrl-shift-enter either. Thank you 🙏🏽 soooo much!

[@JerzeeGirlinPA]

Thanks so much for this tip. I've been trying to calculate the error value for hours. You definitely have a nee subscriber here.

[@StaticPlaya]

You are a life saver. Thank you.

[@rpark8265]

Thanks first formula worked a treat

[@bilal4haider]

Hello, mam some rows only have non-numbers (alphabets), then what would be the method to ignore the #DIV/0 error while applying average formula.?? please help

[@banner78745]

Very helpful! Thank you.

[@drrkvar5659]

thanks ..simple explanation

[@Lieutenant132]

You saved my day. Thank you very much. 😍😍💖💖

[@bazhughes5625]

Helped me hugely, thanks so much :)

[@yeerbolatialimila3821]

You saved my day!

[@pitawtiebogle]

Thank you, that is very helpful.

[@jozee4839]

You rock! Thanks.

[@AmitSinnar]

thanks , so much help full

[@bertusd100]

Thank you so much - a great lesson!!

[@itsahmedkhan]

Thanks, you saved my life :)

[@Samim1]

I have a problem with Average and Sum. When I Separately want to make the Average or the Sum of only one row, the Average or the Sum is calculated but on the left up corner of the cell appears a triangle which indicates that something is wrong with the calculation. I don't know how to fix this problem.

[@winvictorywin5612]

Thanks 🙏

[@ventureelect]

Does not work on two sells for me.

[@ganesh-5079]

SEND THE FORMULA