# How can I sum numbers in an array?
**URL:** https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405
**Category:** Ask for Help
**Created:** [November 11, 2021, 6:06pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405 "2021-11-11T18:06:48Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [November 11, 2021, 6:06pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/1 "2021-11-11T18:06:48Z")
Any quick tip on how to sum numbers in an array?
I would like to add a column that sums the numbers in the array of numbers in the last column. The array is a simple list of numbers, appended by the row.
---
### Author:  [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)
#### Post date: [November 11, 2021, 7:27pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/2 "2021-11-11T19:27:22Z")
Use a rollup column
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [November 11, 2021, 7:34pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/3 "2021-11-11T19:34:48Z")
Nope. Doesn’t work… the sum option is not available.
---
### Author:  [@BlakeWS](https://community.glideapps.com/u/BlakeWS)
#### Post date: [November 11, 2021, 8:03pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/4 "2021-11-11T20:03:34Z")
Related: I would like the count of instances of an item from an array.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 11, 2021, 11:10pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/5 "2021-11-11T23:10:03Z")
Interesting! 🤔
I didn’t know that a Rollup column can count the items of array in each row, thanks for the tip!
However, your goal is the sum right?.. I think a customized JS code can do it easy:
This is my code by using an EC:
```auto
let len=p8.length;
let x=0, total =0;
while (x< len) {
total+= parseInt(p8[x]);
x++ ;
}
return total
```
The problem here is that [Glide’s JavaScript plugin](https://www.glideapps.com/plugins/hell-yes-code) does not support an array as input value so you must use another version or create a new version of that JavaScript plugin.
Maybe @david can read this note and carry out an improvement of his plugin to support these cases.
My version to work with this case runs on Replit:
> [https://SNB-YesCode.gustavovalero.repl.co](https://SNB-YesCode.gustavovalero.repl.co)
Hope it helps you!
Feliz noche @Simon_Hill
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 11, 2021, 11:27pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/6 "2021-11-11T23:27:28Z")
What are you using to get that rolling total array? Seems like it’s being read as text.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 12, 2021, 12:58am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/7 "2021-11-12T00:58:04Z")
Right!
It is the reason why I use **parseInt()** in the code. This covers all cases so far.
**Edited**
I already know what you mean Thind, of course, if the arrays have numeric values the Rollup operation would have worked perfectly!!
Saludos!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 12, 2021, 1:04am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/8 "2021-11-12T01:04:24Z")
This seems like an oversight. @mark @david?
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [November 12, 2021, 2:08am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/9 "2021-11-12T02:08:07Z")
What is this `Rolling total array` column? How is it configured? Glide does not recognize it as an array of numbers.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 12, 2021, 2:26am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/10 "2021-11-12T02:26:44Z")
> [@BlakeWS](#):
>
> 
Hola @BlakeWS
You can try with this JS code until Glide’s JavaScript plugin can support arrays as input values (parameter)
```auto
let len=p8.length;
let total=0;
for (let x= 0; x< len; x++) {
if (p1==p8[x])
total ++
}
return total
```
My Source’s URL on Replit is :
> [https://snb-yescode.gustavovalero.repl.co](https://snb-yescode.gustavovalero.repl.co)
Saludos!
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [November 12, 2021, 3:08am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/11 "2021-11-12T03:08:37Z")
@gvalero or:
```auto
return p8.filter(x => x === p1).length
```
😉
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 12, 2021, 3:16am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/12 "2021-11-12T03:16:47Z")
Right!
I had forgotten the Filter() method 🥴
Sometimes I like the old-programming school (C++) 😀
Gracias por el tip @david
---
### Author:  [@BlakeWS](https://community.glideapps.com/u/BlakeWS)
#### Post date: [November 12, 2021, 3:22am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/13 "2021-11-12T03:22:47Z")
Thanks @gvalero & @david , it works great.
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [November 12, 2021, 8:10am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/14 "2021-11-12T08:10:16Z")
Hi David, thanks for taking the time.
Here is a quick video to explain… I think you’re right, Glide does not recognize the array is comprised of numbers.
Any quick fix?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 12, 2021, 8:45am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/15 "2021-11-12T08:45:32Z")
hmm, I’m surprised that isn’t working. Will be interested to see what the outcome is…
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [November 12, 2021, 9:43am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/16 "2021-11-12T09:43:00Z")
Interesting to note that the roll-up with sum works on the full array of 12 numbers. It stops working after splicing the array.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 12, 2021, 10:15am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/17 "2021-11-12T10:15:24Z")
yeah, kinda suggests that the Array Splice isn’t actually returning an array.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 12, 2021, 11:28am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/18 "2021-11-12T11:28:52Z")
Hola Darren,
I think the Slice Array plugin is doing its job but the result is always a Text therefore, the Rollup column can’t sum text values.
Bye
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 12, 2021, 11:49am UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/19 "2021-11-12T11:49:56Z")
yes, that’s what I meant. It’s not returning an array.
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [November 12, 2021, 1:33pm UTC](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405/20 "2021-11-12T13:33:17Z")
Yes! I bet the array columns all deal with arrays of ‘primitives’, which allows them to work on arrays of anything, but this causes the resulting array to lose type information (the Slice Array column ‘forgets’ what kind of array it’s slicing).
In regular programming, the solution to this is called Generics or polymorphism. I have some research projects to discuss with @Ivo_Elbert about this soon.
[Next page](https://community.glideapps.com/t/how-can-i-sum-numbers-in-an-array/34405.md?page=2)