Thread: How to omit blank cells when calculating weighted averages
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
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(--(B5:D5),(B2:D2))/(IF(ISBLANK(B5),0,B2)+IF(ISBLANK(C5),0,C2)+IF(ISBL ANK(D5),0,D2))

Reply With QuoteReply With Quote