Hi all, There is an old bug i65221( https://issues.apache.org/ooo/show_bug.cgi?id=65221). It is about interoperability with Excel for SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ... with empty cells and "" and ="" empty string criteria.
There is some discussion about it, but no conclusion. Some people think Excel does not do well, so simply mimicking Excel behavior might not be the best idea. Some people think self-consistency in Calc is more important. Some people think compatibility with Excel is a huge concern. IMHO, compatible with Excel is very important. I suggest changing these formulas behavior according to Excel. Following is my consideration 1)Most people use Excel, compatible with Excel is very important. Excel does not show self-consistency in some scenarios, Calc doe not show self-consistency either. 2)Some frequently used function, such as calculating empty cells, can not be implemented by Calc, while Excel can. 3)Although Excel does not show self-consistency in some scenarios. These scenarios are all related with pure empty cell. Excel use following rules When empty cell is criteria, only cells with value 0 meet it. This is true for COUNTIF, SUMIF. But not true for DSUM/DCOUNT/IF. When an empty cell in a cell range, it can meet empty string criteria. This is true for COUNTIF, SUMIF. But not true for DSUM/DCOUNT.
