I have been trying to get an average formula to work and not matter what I try it doesn't.
=AVERAGE(H335+H323+H311+H299+H287+H275+H263+H251+H239+H227+H215+H203+H191+H179+H167+H155+H143+H131+H119+H107+H95+H83+H71+H59+H47+H35+H23+H11)
(The cells listed have formulas in them)
I do not want to include zeros or blanks in the average but no matter what I try it either includes zeros in the count or I get an error.
Hi Julie
Without knowing what your report structure looks like or what is between cells H11 and H23 etc. it is difficult to give you an accurate workaround.
You can refer to my attachment and see if it can be adapted to your situation.
Hope this helps.
Sunny
Hello Julie,
As Sunny shows very well in his example, you can use AVERAGEIF(S) to avoid zeros. Not sure if you have checked this article, if not then it might help you with this. https://www.myonlinetraininghub.com/excel-average-averageif-and-averageifs
Anders I have that article. It was helpful but I can't figure out how to write the formula for averageif/s.
Sunny that worked! Plus the formula was simple to understand!!! Thanks so so very much!
Hi Julie
Thanks for your feedback.
Glad it is working for you.
