sumifs - Any idea why this formula would through an error on google sheets?

Question

=SUMIFS('Test 2021'!M3:M200,'Test 2021'!H3:H200,"Cualitativo",'Test 2021'!K3:K200,"Gestores")

question from:https://stackoverflow.com/questions/65841929/any-idea-why-this-formula-would-through-an-error-on-google-sheets

Answer 1

Your locale may require the use of semi-colons instead of comma's. So see if this works:

=SUMIFS('Test 2021'!M3:M200;'Test 2021'!H3:H200;"Cualitativo";'Test 2021'!K3:K200,"Gestores")

or

=SUMPRODUCT('Test 2021'!H3:H200="Cualitativo";'Test 2021'!K3:K200="Gestores"; 'Test 2021'!M3:M200)