Hello All,

I would like to ask for your help. I would like to know what function to use to get the average of the below data excluding all zeros.

Please see below sample.

N/R = 0
A = 1

Thanks a lot...


N/R 0
A 1
A 1
A 1
A 1
A 1
A 1
N/R 0
A 1
A 1
N/R 0
N/R 0
N/R 0
N/R 0
N/R 0
0.53