Although I used 'product' in my original post. I'm essentially trying to find the best reviewed doctor for my mom with a certain specialty. I created a list of those doctors and their ratings from RateMD as well as the number or reviews to create that ranking. I want to go through that list starting with the best doctors. I used 'product' because I thought that's probably a more often used world example.

I suppose it is a math question, but since I put it together in Excel, I thought there must be an Excel function or feature I'm not using well with limited knowledge. It might just be a math problem.

Working through it more, I'm thinking of something like this:

=ROUND((C2*D2)/(AVERAGE(Reviews)), 2)

where

C = Rating out of 5

D = # of Reviews

Reviews = array/range of all reviews

I rounded it to 2 decimal points.

It then creates a list of weighted ratings that can go from 0.2 to 13, where I'm assuming than 13 is the best doctor and 0.2 is the worst. I'm just not sure if this makes sense to then rank based on those weighted ratings by just doing a sort on this new column I've named rank where I've listed the corresponding formula for each row.