How to omit blank cells when calculating weighted averages
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(D4:D24)/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
|