AVG (zero shall not included)

  • Thread starter mroks via AccessMonster.com
  • Start date
M

mroks via AccessMonster.com

i want to average the below data.

July - 98
August -85
Sept- 0
October- 80
November -75

How could i calculate it, i would like not to affect the result by zero.

The formula should turn like this. avg(98+85+80+75)

thanks.
 
Top