Log In
Register
Home
November 8, 2018
Offline
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.
VIP
Trusted Members
June 25, 2016
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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.myonlinetraininghu.....averageifs
November 8, 2018
Offline
Anders I have that article. It was helpful but I can't figure out how to write the formula for averageif/s.
