Formula to calculate points derived from rankings?

[Janerro]

Not too sure how to articulate my ask, but here goes:

I'd like to be able to correlate the weekday 1-5 ranks to their corresponding point values, and also be able to sum for total weekly points per person. Are there any formulas I can use to do this?

 

[alansidman]

Show us your expected results for your sample. However, you have only shown three days but expect answer for five days. Please expand your sample

 

[kweaver]

Is this what you mean?

042523FunctionSyntax.xlsm
	B	C	D	E	F	G	H
31	Name	Mon	Tue	Wed
32	Person 1	1	4	3	12.5	Rank	Points
33	Person 2	5	5	5	30	1	0
34	Person 3	3	3	2	12.5	2	2.5
35						3	5
36						4	7.5
37						5	10
RDate

Cell Formulas
Range	Formula
F32:F34	F32	=SUM(INDEX(H$33:H$37,C32:E32))

 

[kweaver]

Or maybe per @aladsidman you mean:

042523FunctionSyntax.xlsm
	B	C	D	E	F	G	H	I	J	K
31	Name	Mon	Tue	Wed	Thu	Fri
32	Person 1	1	4	3	2	2	17.5		Rank	Points
33	Person 2	5	5	5	0	0	30		1	0
34	Person 3	3	3	2	5	5	32.5		2	2.5
35									3	5
36									4	7.5
37									5	10
RDate

Cell Formulas
Range	Formula
H32:H34	H32	=SUM(INDEX(K$33:K$37,C32:G32))

 

[Janerro]

Thank you so much!

 

[kweaver]

Did the last one accomplish what you wanted? If so, please mark it solved. Glad to help.