Get the average of a text base rating system in Google Sheets

[@55eco]

Great tutorial! I'm starting to stay away from ArrayFormula and trying to stick with newer LAMBDA functions to be more compliment to Excel (though it's sometimes painful to work in Excel :). Something similar would be =CHOOSEROWS(D2:D6,ROUND(REDUCE(0,B2:B8,LAMBDA(acc,cur, acc+XLOOKUP(cur,D2:D6,E2:E6)))/COUNTA(B2:B8),0)) Just to add in a bunch of formulas :)

[@yagisanatode]

Thank Daniel. Great alternative. I actually a small tutorial in the pipeline using CHOOSEROWS.