[Libreoffice-bugs] [Bug 144889] SUMIFS

[bugzilla-daemon at bugs.documentfoundation.org]

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

GerardF <gerard.fargeot at orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |gerard.fargeot at orange.fr

--- Comment #2 from GerardF <gerard.fargeot at orange.fr> ---

> For each row, the value of column A should be summed if *either* the value of
> column B or C matches the word D.

You misunderstood the purpose of the SUMIFS function.
Replace the word *either* by *both*, and you have the correct definition of the
function.

SUMIFS sum cell that meet all criteria for each row.
=SUMIFS(A:A,B:B,"*apple*",C:C,"*apple*")
adds A1 if B1 *and* C1 contains "apple"
     A2 if B2 *and* C2 contains "apple"
etc...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211003/1b33b07b/attachment-0001.htm>