Tip for #GoogleSheets: instead of just sum(range), use sum(arrayFormula(1*range)). It is more strict for invalid input. See https://webapps.stackexchange.com/q/123627/142561 for more details and tests of various solutions.
Vít Šesták před 3 týdny