https://bugs.documentfoundation.org/show_bug.cgi?id=148747
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #24 from m.a.riosv <[email protected]> --- What you have in Calculation.D1 it is not a date but text. So can't be used to search for a date. Introduce in it 31/01/2022, and if you like format as MM.YYYY. But you need to change the formula, if you want to use SUMIFS D2: =SUMIFS($Statement.$E:$E;$Statement.$C:$C;"*"&$'Help data'.$A5&"*";$Statement.$A:$A;">="&DATE(YEAR(D$1);MONTH(D$1);1);$Statement.$A:$A;"<="&D$1) or with SUMPRODUCT, but using entire columns degrades too much the performance because doesn't shortcut at the end of data, it calculates the whole rows. d2: =SUMPRODUCT($Statement.$E2:$E9999;IFERROR(SEARCH("*"&$'Help data'.$A$8&"*";$Statement.$C2:$C9999;1);0);MONTH($Statement.$A2:$A9999)=MONTH(D$1)) -- You are receiving this mail because: You are the assignee for the bug.
