Thread: How to omit blank cells when calculating weighted averages
View Single Post
  #15  
Old October 29th, 2008, 02:26 PM posted to microsoft.public.excel.worksheet.functions
Suzy
external usenet poster
  
Posts: 39
Default 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(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