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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AVG (zero shall not included) 2
Mapping strings to integers 6
Need help with a formula 4
Avg % above 0% 2
Find components of an Average Result 6
Month days over a time period 5
Taking Average ignoring #DIV/0! in the range... 1
Exclude zeros from pivot table averages 1

Top