Conditional Weighted Average

[ZootRot]

Excel 2003 SP2

Three columns in a data sheet: Country, Number B, Number C.

In a summary sheet, I have a list of the countries and want to create a
formula which calculates the B-weighted average of C, for each Country in
the list.

Is this possible?

Thanks.

 

[Bob Phillips]

=AVERAGE(B2:B4*C2:C4)

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[ZootRot]

Thanks for your response, but that doesn't work. I'm specifically looking
to consider a third factor (A) so I can just copy down the cells.

 

[Bob Phillips]

What third factor? Give an example.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)