CODEWITHSUNDEEP
google-sheetssumifs
Judit Casacuberta Bagó
Judit Casacuberta Bagó

Reputation: 21

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

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

Upvotes: 0

Views: 37

Answers (2)

JPV
JPV

Reputation: 27242

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)

Upvotes: 0

player0
player0

Reputation: 1

try:

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

Upvotes: 1

Related Questions