View Single Post
  #7  
Old October 23rd, 2008, 08:19 PM posted to microsoft.public.excel.worksheet.functions
Suzy
external usenet poster
 
Posts: 39
Default How to omit blank cells when calculating weighted averages

Hi Tom, thanks so much!! That was so helpful!!

Can you tell me how it calculating the weights? How are the weights
redistributed if it isn't 50-50?


"TomPl" wrote:

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