Yes. That's why I included =AVERAGE(D424) as one of my 2 suggestions.

And for further information you could try hitting the F1 key and typing the
word Average.
RTFM doesn't have to be the *last* resort.
--
David Biddulph

"Suzy" wrote in message
...
Hi David,

AVERAGE omits the blank cells, right?

Thanks,
Suzy

"David Biddulph" wrote:

Have you tried =SUM(D424)/COUNT(D424) or =AVERAGE(D424) ?
--
David Biddulph

"Suzy" wrote in message
...
Hi Tom,

Can you help me with another formula? I am also calculating the
averages
of
each particular assignment in the class. How do I omit the blank cells
from
the class average for the assignment?

The formula is:

=SUM(D424)/21

Thanks!!

Suzy


"TomPl" wrote:

The formula will work equally as well with percentages as with credits
so
I
think it should do what you asked.

Good luck with it.

Tom