https://bugs.documentfoundation.org/show_bug.cgi?id=159544
--- Comment #3 from ady <adylo811...@gmail.com> --- In attachment 192374 worksheet Sheet2 cell D6, the formula is: =COUNTIFS($Sheet1.D:D;"";$Sheet1.A:A;A6;$Sheet1.B:B;B6;$Sheet1.C:C;C6) Changing that to: =COUNTIFS($Sheet1.A:A;A6;$Sheet1.B:B;B6;$Sheet1.C:C;C6;$Sheet1.D:D;"") (i.e. moving Range1 and Criteria1 to the last pair of arguments) generates the correct result in a recent LO 24.8 alpha. I'm not sure why the order of the pair of arguments would make any difference (when the formula is in a different worksheet), but it does. -- You are receiving this mail because: You are the assignee for the bug.