Filter

[Venkatsj]

Hi Kindly help me with the below query,

No of times
0
1
2
3
5
6
8
10

From the above table I need to calculate average only for the values greater than "0". Also empty cells need to be excluded. Please help me with the expression, thank you 

[MayilVahanan]

HI

Try like below

=Avg({<[No of times]={">0"}>}[No of times])