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

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 :)