Calculate weighted averages using high, medium, low

As Ron indicates it is difficult to be sure what you are after from your post.
However, is this what you are after?

=SUMPRODUCT(B2:B11,C2:C11)/SUM(C2:C11)

Mark.

Not sure how to use SUMPRODUCT for this, but I don't have much experience with that function. If nothing else, you could create a table:

In the range D1:D3, put:
Low
Medium
High

Next to that in E1, put:

=SUMIF(B:B,D1,C:C)

and fill down to E2 and E3

If you simply want an answer of either high medium or low, you would simply take the MAX of these.

I’m trying to compare two sets of features (real estate properties) to see which set (or property) has a higher average. If a feature exists it is rated as having a High value, if it doesn’t exist it’s rated as Low but if a feature exists but has some faults, it is given a Medium value.

Then, there are some features that are better to have than others, so I’ve added weighted values of 1-3. So with all other things being equal, if a property has a Pool but no screened in porch, it gets a 3 weight for that feature, which beats a property that has a screened in porch but no Pool which would only get a 2. The Weighted Average calculation is =SUMPRODUCT(B2:B11,C2:C11) and works if I’m using numbers but I’d like to keep the High, Medium, Low selection but equate a 3, 2 or 1 to these values in order to perform the calculation.

Features         Value     Weight
Feature 1        High      1
Feature 2        Medium    3
Feature 3        Low       1
Feature 4        High      2
Feature 5        Medium    3
Feature 6        Low       1
Feature 7        High      2
Feature 8        Medium    2
Feature 9        Low       1
Feature 10       High      1
          
          
Weighted Average           37

Many thanks! This worked just as expected.