https://bugs.documentfoundation.org/show_bug.cgi?id=168695
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Mike Kaganski <[email protected]> --- What you describe is exactly what is is intended to do. This is explained in the documentation for e.g. SUMIF [1] : > If the optional range S is included, then the values of S starting from the > top > left cell and matching the geometry of R (same number of rows and columns) are > summed if the corresponding value in R meets the Criterion. In your example, D2 would only be summed, if you used B2:C1000 in the first argument, and C2 would happen to match the criterion. The functions do *not* consider a single match in B2 as validating the "whole row" in the third argument; only one element in third argument matched one element in first argument. Not a bug. [1] https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#__RefHeading__1018584_715980110 -- You are receiving this mail because: You are the assignee for the bug.
