Thread: How to omit blank cells when calculating weighted averages
View Single Post
  #6   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
Though it does the same thing, I like this formula a little better:

=SUMPRODUCT(B5:D5,$B$2:$D$2)/SUMPRODUCT(--((B5:D5)0),$B$2:$D$2)

Tom
Reply With QuoteReply With Quote