Bug 78516 - "=?" conditional not recognized in SUMIF function
Summary: "=?" conditional not recognized in SUMIF function
Status: RESOLVED DUPLICATE of bug 38125
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-10 03:05 UTC by tammicd
Modified: 2014-05-10 07:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tammicd 2014-05-10 03:05:11 UTC 
Simple example: column A has numbers to be summed, but only add the values from A if the corresponding cell in column B is not blank.

=SUMIF(B1:B5,"=?",A1:A5)


A B
---
3 A
4 A
4 B
5
2

With this data, the formula should give result 11 (the sum of the first 3 values in column A). but Calc from Libre Office Version: 4.2.3.3, Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff0
returns a value of zero. Microsoft Excel will return the correct value.
Comment 1 GerardF 2014-05-10 07:05:36 UTC 
Microsoft Office use "Wilcards",
LibreOffice use REGEX.

There is an enhancement request to provide LO using wilcards also.

*** This bug has been marked as a duplicate of bug 38125 ***