Create a tally of point accumulation based on finishing positions in multiple tournaments

Hi folks. Here's a rundown of what I'm trying to achieve:
Imagine a Chess championship, run across a country. Let's choose Australia for example.
There are 6 tournaments, followed by a 'grand final' between the top 4 competitors (based on accumulated points) at the end of the year.
Allocating points would be easy enough with a formula, but I'm hoping to have the points automatically allocated to a person's name determined by which cell it sits in.
For example, John is 1st in Perth, netting himself 100 points (as a standard event), and also 1st in Sydney, gaining 160 points (major event). So those figures and all other results will come across into a tally in another column, preferably in order of total points by player, highest to lowest. From there a grand finals can be auto-populated with simple A=B formulas.

Any help would be much appreciated, I figure it might not be possible with regular formulas (??) and needs VBA macros, which I'm no expert at using...
The main function is to give a cell a value for the name I input, eg, B3 allocates 100 points to whichever name appears in it. Hope that makes sense.


tournament example jpeg.png


tournament example.xlsx

Let's try with formulas.

I'd prepare small helper table summarizing results, and then use it as a base to find 4 best players.
For instance in M3:M10 list of players, then in N3 array formula (Ctrl+Shift+Enter committed) :

Formula:

Please Login or Register  to view this content.

copy it down, and in O3 (also copy down):

Formula:

Please Login or Register  to view this content.

then in H3 (and copy down 3 cells):

Formula:

Please Login or Register  to view this content.

see attached file