Thread: How to omit blank cells when calculating weighted averages
View Single Post
  #6  
Old October 22nd, 2008, 05:10 PM posted to microsoft.public.excel.worksheet.functions
TomPl
external usenet poster
  
Posts: 239
Default How to omit blank cells when calculating weighted averages
Though it does the same thing, I like this formula a little better:

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

Tom