https://bugs.documentfoundation.org/show_bug.cgi?id=166251
--- Comment #16 from Julien Nabet <[email protected]> --- (In reply to gmarco from comment #15) > (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 ! gmarco is right, product names should have been adapted and not only translated. Indeed, in English, =SUMIF(A2:A6,"pen*",C2:C6) gives 150 since, we have: - C2 (65) which is in the same row as "pencil" A2 - C3 (85) which is in the same row as "pen" A3 but in Italian, only A3 "penna" corresponds to the criteria "pen*", so we should have only 85 and not 150. There's exactly the same problem in French and certainly in other languages. -- You are receiving this mail because: You are the assignee for the bug.
