I am trying to use sumif function but it alwasy returns me 0, at the beggining I was using , instead ; for europe, changed that but it keeps giving me 0

CodePudding user response：

use:

=SUMIF(I1:I4; "a"; H1:H4)

or:

=SUMIFS(H1:H4; I1:I4; "a")

or:

=SUM(FILTER(H1:H4; I1:I4="a"))