https://bugs.documentfoundation.org/show_bug.cgi?id=143809
--- Comment #1 from Mike Kaganski <[email protected]> --- It looks related to INF. Replacing its reference in LAST_ROW by its expression, like this: > LAST_ROW: MATCH((2^53-1)*2^(1024-53);$Tickets.$A:$A) fixes the problem. It turned out that I made a mistake while preparing the example, moving IFERROR's last argument out of the argument list - that's unrelated; the correct formula in Billing.A1 / Tickets.D1 is > =SUMPRODUCT(IFERROR(CEILING.MATH(DURATIONS;300);0)) and in Billing.A2 / Tickets.D2 is > =SUMPRODUCT(IFERROR(CEILING(SUMIFS(DURATIONS;IDS;IDS);300)/COUNTIFS(IDS;IDS);0)) Why could INF cause this? There's no built-in function named so. -- You are receiving this mail because: You are the assignee for the bug.
