Issue 53946 - SUMIF with single "=" criteria denoting empty cell doesn't work
Summary: SUMIF with single "=" criteria denoting empty cell doesn't work
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 25808 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-08-30 08:24 UTC by spiree
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Simple Excel example using SUMIF (13.50 KB, application/vnd.ms-excel)
2005-08-30 08:25 UTC, spiree
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description spiree 2005-08-30 08:24:35 UTC
à have a simple spreadsheet that sums the values in column B if the 
corresponding row in column A is empty. This works fine in Excel but 
apparently fails to work in OO.

See attachment. The result in Excel is "2" (since two cells in column A are 
empty) but in OO it's "0".
Comment 1 spiree 2005-08-30 08:25:43 UTC
Created attachment 29157 [details]
Simple Excel example using SUMIF
Comment 2 frank 2005-09-21 14:34:28 UTC
Hi Eike,

one for you. It's in there at leasrt since SO5.2.

The worst thing is that the opposit way, criteria changed to "<>" works perfectly.

So if possible re-target this one.

frank
Comment 3 ooo 2005-12-15 00:35:11 UTC
Accepted.
Comment 4 ooo 2005-12-15 00:47:12 UTC
*** Issue 25808 has been marked as a duplicate of this issue. ***
Comment 5 mathieuparent 2006-12-14 15:57:36 UTC
linked with issue 65221 ?
Comment 6 ooo 2006-12-14 18:25:29 UTC
Yes and no. This issue here is a special case of the "just an equal sign" for
comparing against emptyness, it is solvable without finding a consolidation for
issue 65221.
Comment 7 Stefan Weigel 2008-09-10 17:41:11 UTC
+me to CC
Comment 8 Marcus 2017-05-20 11:13:46 UTC
Reset assigne to the default "issues@openoffice.apache.org".