https://bugs.documentfoundation.org/show_bug.cgi?id=131927

Olivier Hallot <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|[email protected] |olivier.hallot@libreoffice.
                   |desktop.org                 |org

--- Comment #6 from Olivier Hallot <[email protected]> ---
Actually - and this is not clear in the Help text - Criterion must result in a
string expression or cast into a string expression.

So whatever formula you put in Criterion, it works as long as it results in a
string.

in case of comment#0 

SUMIF(G4:G66;"="&G68;D4:D66)

criterion is concatenation of "=" with whatever is the contents of G68.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to