Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function filteredSum(){
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var tsheet = ss.getSheetByName("Sheet1");
- var originalData = tsheet.getRange(10, 1, tsheet.getLastRow()-1, 2).getValues();
- var mindate = tsheet.getRange("C8").getValue();//starting date
- var maxdate = tsheet.getRange("D8").getValue();//end date
- var data = originalData.filter(function(item){return item[0] >= mindate && item[0] <= maxdate});
- Logger.log(data);
- //here i got the array of arrays. and i'm stuck. how to get the sum of numbers
- }
- var sum = data.reduce(function(a,b){
- return a + b[1];
- }, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement