How to omit Zero scores when Averaging?
Posted by J on March 30, 2001 9:08 AM
Iam attempting a simple average of a row of grade scores.
The scores sometimes are Zero,
and I want to exclude these Zero's from the average.
The numbers are derived from another place on my spreadsheet
which shows 0 when a test is not given or taken.
A sample of the formula being used now:
Is there a way to average and exclude any "0" entries
from the average calculation?