Issue 116178

Summary: SUMIF Bug when Comparing Against "" (For Blank Cells)
Product: Calc Reporter: dgm0814 <dennis.moore>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues, oliver.brinzing
Version: OOo 3.2.1   
Target Milestone: ---   
Hardware: PC (x86_64)   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Description dgm0814 2010-12-19 22:52:14 UTC


This should sum up B1:B3 if the cells C1:C3 are blank.  This does work in Excel 
but does not work in Open Office.

NOTE:  If you do =if(A2="","IsBlank","IsNotBlank") the "" works to compare for a 
blank cell.  SumIf should do the same.
Comment 1 Oliver Brinzing 2010-12-20 17:28:45 UTC
workaround: =SUMPRODUCT(C1:C3="";B1:B3)
Comment 2 dgm0814 2010-12-21 00:20:16 UTC
This did resolve my issue for new excel documents I create, but does not help 
with documents that are sent to me.

Hopefully this is resolved in a future release as this has caused some problems 
in financial documents that have been sent to me for review.

Thanks for the workaround.
Comment 3 Edwin Sharp 2013-08-22 18:18:36 UTC
Created xls with Excel 2010.
Opened with Rev. 1513819.
=sumif(C1:C3,"",B1:B3) gives 0 instead 21 when C1:C3 are empty and B1:B3=7,7,7.