Size: a a a
В
AS
ДХ
EN
В
ДХ
v
/**
* customfunction
*/
function SUMMS(address){
var [sheet,A1Not]=address.split("!")
var reg=new RegExp(sheet.split(/["']/)[1])
var sum=0
var sheets=SpreadsheetApp.getActiveSpreadsheet().getSheets()
for (var sh of sheets){
if (reg.test(sh.getName())){
sum += sh.getRange(A1Not).getValue()
}
}
return sum
}
ЮК
u
VP
В
VP
VP
ЮК
u
ЮК
u
v
/**
* customfunction
*/
function SUMMBETWWEN(address){
var [sheet,A1Not]=address.split("!")
var sheetsB=sheet.split(/["']/)[1]
var [start,end]=sheetsB.split(":")
var sum=0
var sheets=SpreadsheetApp.getActiveSpreadsheet().getSheets()
var startSh=sheets.find(sh=>sh.getName()==start).getIndex()
var endSh=sheets.find(sh=>sh.getName()==end).getIndex()
for (var sh of sheets){
let ind=sh.getIndex()
if (ind>=startSh&&ind<=endSh){
sum += sh.getRange(A1Not).getValue()
}
}
return sum
}NA