1 | initial version |
One way to add up items in an array with two dimensions using Google Apps Script is to use a nested for loop. Here is an example:
function sumArray(array) {
var sum = 0;
for (var i = 0; i < array.length; i++) {
for (var j = 0; j < array[i].length; j++) {
sum += array[i][j];
}
}
return sum;
}
// Example usage
var myArray = [[1, 2], [3, 4], [5, 6]];
var total = sumArray(myArray);
Logger.log(total); // Output: 21
In this example, the sumArray
function takes an array with two dimensions as its argument. The function uses a nested for loop to iterate over each item in the array, and adds each item to the sum
variable. Finally, the function returns the total sum of all the items in the array.
To use this function with your own array, simply replace myArray
with your array variable in the example usage.