Report a bug :
example,
Row A : 1,2,3,4,5
Row B : (Blank),b,c,(blank),e
Cell C1: =SUMIF(B1:B5,B1,A1:A5)
Results are Excel:0,: Onlyoffice:5
App version:
Downloaded from: ONLYOFFICE website in December 2025
Community Editions 9.2.1.43 (x64 exe)
Hi @r.Kermit,
Interesting feature to bump into.
I would argue the point that OnlyOffice gets it correct, and MS Excel gets it wrong. 
Excel does yield a result of 5 when the formula is coded;
=SUMIF(B1:B5,"="&B1,A1:A5)
… or
=SUMIF(B1:B5,CLEAN(B1),A1:A5)
which explicitly forces Excel to match against the null value in B1. OnlyOffice accepts either formula.
Excel’s documentation does say that the SUMIF function does not work when the data contains “#VALUE!” results, and suggests that “non-printable characters” are part of this criteria, of which null is “non-printable”.
Personally, I don’t think this is a bug. But we should see what the OnlyOffice support team thinks. Care should be taken when dealing with null values in your data, and OnlyOffice appears to have better nullables support.
Hello David,
Thanks.
I agree, it is Excel bug, Result should be 5.
2 Likes
Hello @r.Kermit, @DavidRGreen
The difference is that ONLYOFFICE editors treat truly empty cells as comparables, while Excel has a strict model for the empty values. Functions expect a value in cells to be real values, but empty cell in Excel is not a real value. There are some quirks though.
For instance, if you change the function in Excel to =SUMIF(B1:B5;"";A1:A5), it will return 5, because "" is an empty string, a real value, but truly empty cell is not. Original function with truly empty cells compares non-existent values in cells, thus returns 0. However, function like =B1="" in Excel should return FALSE by the concept, but results in TRUE, which should not be the case.
ONLYOFFICE editors treat truly empty cells and cells like "" as equals, thus allow calculation. This is just more intuitive way to work with values.
1 Like