https://bugs.documentfoundation.org/show_bug.cgi?id=144889
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED CC| |[email protected] --- Comment #2 from GerardF <[email protected]> --- > 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.
