View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hile Hile is offline
external usenet poster
 
Posts: 45
Default Sumproduct seems off... HELP PLEASE!

WinXPPro SP3, Excel 2k

OK so I'm using sumprod and something just doesn't seem right. Col B should
clearly have a higher weighted average than Col C. Can anyone see what's
wrong, or should I just pack up and go home for the day! :-)

29.00% 5 3.3
71.00% 5 4
WA: 1.45 3.80

Col B formula: SUMPRODUCT(B1:B2,$A$1:$A$2)
Col C formula: SUMPRODUCT(C1:C2,$A$1:$A$2)

--
Hile