Sum of numbers in array

[Hassan_Nadeem]

Need help with writing a complicated google sheet formula on Glide tables

sure… var x = [['A',1],['B',2],['C',3],['D',4],['E',5],['F',6],['G',7],['H',8],['I',9],['J',1],['K',2],['L',3],['M',4],['N',5],['O',6],['P',7],['Q',8],['R',9],['S',1],['T',2],['U',3],['V',4],['W',5],['X',6],['Y',7],['Z',8]]; var text = p1.toUpperCase(); var res=0; for(var j=0;j<text.length;++j){ for(var i=0;i<x.length;++i){if(text.slice(j,j+1)==x[i][0]){res=res+x[i][1]}}} return(res)

@ThinhDinh FirstnameScore column is computed using the JavaScript Uzo wrote