https://bugs.documentfoundation.org/show_bug.cgi?id=166251
--- Comment #17 from gmarco <[email protected]> --- (In reply to Julien Nabet from comment #16) > (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. VERY GOOD, thanks!!! -- You are receiving this mail because: You are the assignee for the bug.
