https://bugs.documentfoundation.org/show_bug.cgi?id=166251
--- Comment #15 from gmarco <[email protected]> --- (In reply to Buovjaga from comment #14) > (In reply to gmarco from comment #0) > > The example =SOMMA.SE(A2:A6,"penna*",C2:C6) has a nonsensical description: > > "Adds the values in area C2:C6 only if the values in the corresponding > > area A2:A6 contain the letters "penna". Returns 150 because rows A4:A5 do > > not meet the criterion.", in fact it returns 85. > > What about these problems? "only if the values in the corresponding area A2:A6 contain the letters "penna". Returns 150 because rows A4:A5 do not meet the criterion." As I said, some nonsense: - area A2:A6 ... rows A4:A5 - Returns 150 because rows A4:A5 do not meet the criterion: if the criterion is not met why does it return 150? Was it so, it should be 0 ! But the criterion is just satisfied, "penna" is in A3 and corresponds to the value 85 in C3 ! -- You are receiving this mail because: You are the assignee for the bug.
