# Thread: Weighted Average with SUMIF functions (Excel 2000)

1. ## Weighted Average with SUMIF functions (Excel 2000)

Is there a way to calculate weighted average of two columns with sumif functions ? The example is given below. THanks !

A 1 32%
A 3 32%
B 2 5%
C 4 2%
D 1 5%
D 2 2%
D 3 87%

A 4 ??
B 2 ??
C 4 ??
C 4 ??

2. ## Re: Weighted Average with SUMIF functions (Excel 2000)

Not with a sumif BUT
Try this ARRAY (ctrl-shift-enter to confirm)

=SUM(IF(\$A\$2:\$A\$100="A",\$B\$2:\$B\$100*\$C\$2:\$C\$100))
=SUM(IF(\$A\$2:\$A\$100="B",\$B\$2:\$B\$100*\$C\$2:\$C\$100))
=SUM(IF(\$A\$2:\$A\$100="C",\$B\$2:\$B\$100*\$C\$2:\$C\$100))
=SUM(IF(\$A\$2:\$A\$100="D",\$B\$2:\$B\$100*\$C\$2:\$C\$100))

You could also create a column to contain A, B, C, D, etc and link to that column and then just copy the formula
Expand the ranges as appropriate. I don't get your numbers, but I assume the list is NOT complete since NONE of the "letter" total 100%.

Steve

3. ## Re: Weighted Average with SUMIF functions (Excel 2000)

Steve,
Works. Thanks.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•