Taking weighted averages of many different ranges?

[Lycium]

Hi there,

I have little experience with Excel otuside of basic functions so please let me know if what I am trying to do is even possible outside of using a VBA code.

I have around 10,000+ rows that is sorted by county names. Each county in Row A appears a different number of times, for example, County A may appear 5 times in Row A while County B appears 10 times. Each county has a price and quantity sold associated with it. For example, County A(1) has $500 and 2 units and County A(2) has $1000 and 3 units.

Ideally, there is a function that would allow me to take weighted averages of each counties price given the quantity that can take into account that some counties repeat a different number of times. Attached is an example of what I am aiming to do.

Thanks!

[shg]

H3 and copy down,

=SUMPRODUCT(($A$3:$A$14=F3) * ($B$3:$B$14=G3), $C$3:$C$14, $D$3:$D$14) / SUMIFS($D$3:$D$14, $A$3:$A$14, F3, $B$3:$B$14, G3)

[Lycium]

Wow, I saw variations of that formula many times when Googling but didn't think it would work.

Thanks so much! Worked like a charm.