https://bugs.documentfoundation.org/show_bug.cgi?id=148747
--- Comment #28 from JPT <[email protected]> --- (In reply to m.a.riosv from comment #24) > 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)) Thanks for listing the other options. Sometimes I might try to apply them to new tables. It will be easier for me now (if I want to use new versions of LibreOffice) to change the search criteria from "MM.YYYY" to ".M.YYYY" so it works in the new version. Well, at least me. However, it does not work in the old version. -- You are receiving this mail because: You are the assignee for the bug.
