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!
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
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.
Thank you so much for sharing your skills and knowledge!
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!
Thanks so much for this tip. I've been trying to calculate the error value for hours. You definitely have a nee subscriber here.
You are a life saver. Thank you.
Thanks first formula worked a treat
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
Very helpful! Thank you.
thanks ..simple explanation
You saved my day. Thank you very much. 😍😍💖💖
Helped me hugely, thanks so much :)
You saved my day!
Thank you, that is very helpful.
You rock! Thanks.
thanks , so much help full
Thank you so much - a great lesson!!
Thanks, you saved my life :)
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.
Thanks 🙏
Does not work on two sells for me.
SEND THE FORMULA