High, Medium, Low Calculation

[Jayee04e]

Hello everyone! I have simple cells of:
High, medium, low. On the 4th cell to the right would like it to calculate the selection: 3 high, 2 medium, 1 low = TOTAL of 3 combined.

What formula will achieve this total?

 

[Cubist]

Try:

Book1
	A	B	C	D
1	High	High	Low	7
Sheet1

Cell Formulas
Range	Formula
D1	D1	=SUM(XLOOKUP(A1:C1,{"High","Medium","Low"},{3,2,1}))

 

[Jayee04e]

THANK YOU Cubist, this formula is EXACTLY what was needed!