View Single Post
  #4  
Old October 22nd, 2008, 04:44 PM posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_]
external usenet poster
 
Posts: 1,713
Default How to omit blank cells when calculating weighted averages

I think that will reward the absentee... as he will score higher than someone
who gave the test and got 99%.

I would suggest assigning the average of her other two scores as the missing
score, if the weights are same.

"Teethless mama" wrote:

Just treat the missing assigment as a perfect score.


"Suzy" wrote:

Hello, new to Excel and need help with function.
I am calculating grades for my students, and if they were absent, I do not
want them penalized. What function will omit the blank cells when the formula
is calculating the weighted average? I tried the average option but it still
treated the cell as a zero.

Here is the formula:
=((B5*$B$2)+(C5*$C$2)+(D5*$D$2))

When I tried removing the section of the formula for students who were
missing the assignment in B5, the average still remained low. Thanks in
advance!!