=SUMPRODUCT(B1:B4,C1:C4)/SUM(B1:B4)

"Chip" wrote:

Howdy,

I work at a car dealership and we sell both Hondas and Toyotas. I've done a
survey with my customers who own cars. I did this to find out if people who
own Hondas are more satisfied than people with Toyotas.

I want to "average the averages" below to find out if Honda owners are more
happy than Toyota owners. Here's some sample data:

Honda
Product #votes Average satisfaction grade per vote
Civic 1,211 75%
Accord 811 82%
Del Sol 355 55%
Passport 561 55%

Toyota
Corolla 1,356 88%
Camry 334 36%
Supra 284 36%
Landcrser 5 36%

How would I average the averages? Would I use the SUMPRODUCT formula for
each set? In other words, if the Honda set was in columns A through C, I
would do this, right?

=SUMPRODUCT(C1:C4,B1:B4/SUM(B1:B4))