How to calculate average but exclude zero

Question

Hi,&nbsp;&nbsp;May someone kindly help advise how I can calculate the average function but have it exclude any value that is a "0"? The reason is because in my excel, the "0" represent blank cell, it needs to have "0" but I don't want excel to calculate it when averaging.&nbsp;Thank you,Amy&nbsp;

detlef_lewin · Answer

AmyYang&nbsp;Use AVERAGEIFS().&nbsp;

amyyang · Answer

Hi Detlef_Lewin&nbsp; - thank you for your reply!Apologies, I forgot to clarify my actual excel, the numbers are not next to each other so the Averageif function doesn't work as it needs to be side-by-side.Or else it seems could have used&nbsp;=AVERAGEIF(cell range want to average, "&lt;&gt;0")I updated the excel to reflect this as example.May you help advise?&nbsp;Thanks,Amy&nbsp;

detlef_lewin · Answer

AmyYang&nbsp;AVERAGEIFS() still works on your example.&nbsp;

Forum Discussion

How to calculate average but exclude zero

Share

Resources