Thread: How to omit blank cells when calculating weighted averages
View Single Post
  #5  
Old October 22nd, 2008, 04:47 PM posted to microsoft.public.excel.worksheet.functions
TomPl
external usenet poster
  
Posts: 239
Default How to omit blank cells when calculating weighted averages
This formula is complicated and very specific to your description, but it
should accruately calculate the weighted average of the assignments that do
not have a blank in row 5:

=SUMPRODUCT(--(B55),(B22))/(IF(ISBLANK(B5),0,B2)+IF(ISBLANK(C5),0,C2)+IF(ISBL ANK(D5),0,D2))