Forum Discussion
How to calculate average but exclude zero
Hi, 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...
Hi Detlef_Lewin - 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 =AVERAGEIF(cell range want to average, "<>0")
I updated the excel to reflect this as example.
May you help advise?
Thanks,
Amy