I am trying to weight a series of results and the obtain an overall rank.
Here is an example...

locations Result 1 Result 2 Result 3
location1 515 89% 4.5%
location2 431 72% 2.3%
location3 535 n/a 5.0%

Weighting...
Result 1 = 30%
Result 2 = 50%
Result 3 = 20%
Total - 100%

What I am trying to do is determine which location is ranked the highest
overall.

I inititally thought since the results varied in their number format that I
would rank each result by location. ex: Location1 Result 1 Ranked = 2

I then took the rank and * by the weight. ex: Location1 Result 1 Ranked
2*30%

I then did that to each category and added the weighting together and
divided by 100%

I'm honestly not sure if I was correct in the mathmatics of the formula. I
also need to know how to not have a result count if the location did not have
a result. ex: location3 result 2 = n/a. I do not want that to count against
them and need to know how to omit that from the equation. And lastly, If
there is an easier way to obtain this result, I would love to know. I feel
I'm complicating this process when I feel there is a way to simplify the
process.