path: root/offapi
diff options
authorLuboš Luňák <>2022-05-27 19:51:40 +0200
committerLuboš Luňák <>2022-05-28 05:44:27 +0200
commit7674399aac661eb503d7badc53b9a4d68bd9839d (patch)
tree1d5a5ed31a1e10d175da3232cccfe92a0a931fc1 /offapi
parente3d3adbcde43965b517473387acda81e53e248ed (diff)
try to range-reduce even COUNTIFS if not matching empty cellsHEADmaster
It's possible to do reduce range of COUNTIFS to non-empty data too, since empty cells cannot contribute to the result, as long as the criteria do not require matching empty cells. Without this queries like =COUNTIFS($A:$A,...) can spend most of their time clearing and searching the vConditions vector that's big and not useful for the trailing empty cells in that column. Change-Id: I8d1e7977f172ac9b2cf84af3f982e945be3cb46c Reviewed-on: Tested-by: Jenkins Reviewed-by: Luboš Luňák <>
Diffstat (limited to 'offapi')
0 files changed, 0 insertions, 0 deletions