Your column B formula returned 5 when I tried it (which is what I would
expect). I get the 1.45 result you show if my formula is
=SUMPRODUCT(B1:B1,$A$1:$A$1)

Is that the problem?

Hope this helps,

Hutch

"Hile" wrote:

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