Aug 03 2020 04:00 PM
The workaround could be as here https://exceljet.net/formula/3d-sumif-for-multiple-worksheets. It doesn't work with reference like OGuin:Turcotte, with named range of all sheets names. But if the structure is more or less fixed that shall not be a big issue.