How to calculate average but exclude zero

[AmyYang]

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 to have "0" but I don't want excel to calculate it when averaging.

Thank you,

Amy 

[#2]

@AmyYang 

Use AVERAGEIFS().

[#3]

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 

[#4]

@AmyYang 

AVERAGEIFS() still works on your example.