Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
Try like below
=Avg({<[No of times]={">0"}>}[No of times])