Weighted average sort by name

[hfler]

Hello--

I am trying to calculate the weighted average of a column that is organized by name. I already successfully calculated the weighted average of a column organized by number using this formula:

=SUMPRODUCT(--(Master!H4:H10002=1),Master!I4:I10002,Master!F4:F10002)/C4

Where column H contains the category by which I want to sort, column I contains the values for which I want to find the weighted average, column F contains the values I am finding the weight of, and column C is a total of all the values I am finding the weight of.

Hopefully that makes sense. Now, instead of sorting by the number "1", I want to sort by name, for instance, "northeast." Any suggestions?

 

[iliace]

So like this?

=SUMPRODUCT(--(Master!H4:H10002="northeast"), Master!I4:I10002, Master!F4:F10002)/C4

 

[hfler]

that actually did not work for some reason

 

[Domenic]

Does C4 contain a formula? If so, can you post the formula? Assuming that Column G contains the name, such as 'northeast', maybe...

=SUMPRODUCT(--(Master!G4:G10002="northeast"),Master!I4:I10002,Master!F4:F10002)/SUMPRODUCT(--(Master!G4:G10002="northeast"),Master!F4:F10002)

Hope this helps!

 

[iliace]

It might not be exactly "northeast"; the text needs to be exact.

 

[hfler]

That didn't work, thanks though.

 

[Domenic]

Can you post a small sample of the data?

 

[Aladin Akyurek]

Would you answer the question Domenic posed regarding C4: What formula if any do you have in C4?

What is the range which must meet the condition of "northeast"?

 

[hfler]

Column contained the sum of all of the values of column F. Column F is the column by which I am weighting. Maybe there is a more efficient way to do that...

The range for "Northeast" should be between H1:H100000.

I'll post some of the data, too...