The following formula should compute the number of visible rows in a filtered list that also match a further condition:-
In Excel this works fine, but when used in LO Calc it gives an incorrect result - in this case 420838 versus the correct value of 186.
Tested using Excel 2003 in Windows 7, versus LO Calc in Windows 7 and Arch Linux.
Please attach test file, thanks
This report was requested by Eike on Ask.
Created attachment 121410 [details]
Excel test file
test file showing incorrect result in LO Calc versus correct result in Excel 2003
Created attachment 121414 [details]
printscreen from LO and excel
I can confirm with Version: 184.108.40.206.alpha0+ (x64)
Build ID: cfe08df695c046371c4361a434176e6381e3e064
CPU Threads: 1; OS Version: Windows 6.1; UI Render: default;
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-12-15_13:10:55
*** This bug has been marked as a duplicate of bug 58874 ***