When it finds a blank, it will ignore the whole row. Things to Remember If a cell in the given criteria range is blank, the AVERAGEIFS function will count as zero. If the cells don’t meet the criteria, the AVERAGEIFS function shows the #DIV/0! error value. If the range of ...
it('Var1 is array includes blank cells', () => { const var1 = ArrayValueObject.create({ calculateValueList: transformToValueObject([ [null], [null], ]), rowCount: 2, columnCount: 1, unitId: '', sheetId: '', row: 0, column: 0, }); const result = testFunction.calculate(var...