Can I do a sum of numbers in an Array (split text) column? The roll up is counting items in array, not summing it. I found a almost 18 months old thread but couldn’t find the solution. [Screenshot 2023-02-19 053842]

var n = p1, remainder, sumOfDigits = 0; while(n) { remainder = n % 10; sumOfDigits = sumOfDigits + remainder; n = Math.floor(n/10); } return (sumOfDigits) put as p1 result from my first script

Sum of numbers in array

Ask for Help

Hassan_Nadeem February 19, 2023, 1:17am 3

@ThinhDinh FirstnameScore column is computed using the JavaScript Uzo wrote

Topic		Replies	Views
How can I sum numbers in an array? Ask for Help	20	2776	November 12, 2021
Rollup in one sheet recognize one Math column in another as a string Ask for Help	4	314	January 17, 2024
How to sum the array Elements in Glide? Ask for Help	7	426	October 28, 2023
Adition of numbers in a column Ask for Help	5	23	January 30, 2025
How can I calculate the total sum of row values in the sheet? Ask for Help	5	269	October 9, 2023

Sum of numbers in array

Related topics