entire column range function sumHours(range) { return JSON.stringify(range); } is an array of items in which any item is another array containg the cell value, in this case the row |row1| |row2| |row3| is a [["row1"],["row2"],["row3"]]