# Sum of numbers in array

**URL:** <https://community.glideapps.com/t/sum-of-numbers-in-array/58143>\
**Category:** Ask for Help\
**Created:** [February 19, 2023, 12:45am UTC](https://community.glideapps.com/t/sum-of-numbers-in-array/58143 "2023-02-19T00:45:04Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [February 19, 2023, 1:17am UTC](https://community.glideapps.com/t/sum-of-numbers-in-array/58143/3 "2023-02-19T01:17:25Z")

</div>

> [@Need help with writing a complicated google sheet formula on Glide tables](https://community.glideapps.com/t/need-help-with-writing-a-complicated-google-sheet-formula-on-glide-tables/57918/11):
>
> 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

---

_[View the full topic](https://community.glideapps.com/t/sum-of-numbers-in-array/58143)._