Nested ifs resulting in Value error

[Celticfc]

Hi all,

For some reason my code works only for the first IF statement(k14).

When I enter location to K15:k17, it returns Value error.

Could it be something with my brackets?

Thank you.

=IF('landing page'!$K$17="",IF('landing page'!$K$16="",IF('landing page'!$K$15="",IF('landing page'!$K$14=""

,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent")))

,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[COUNTRY]='landing page'!$K$14))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))

,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[REGION],'landing page'!$K$15))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))

,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[DISTRICT],'landing page'!$K$16))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))

,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[STORE],'landing page'!$K$17))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))

=IF('landing page'!$K$17="",IF('landing page'!$K$16="",IF('landing page'!$K$15="",IF('landing page'!$K$14=""
,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent")))
,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[COUNTRY]='landing page'!$K$14))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))
,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[REGION],'landing page'!$K$15))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))
,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[DISTRICT],'landing page'!$K$16))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))
,SUMPRODUCT(((MANAGER1[POSITION]=$D261))*((MANAGER1[STORE],'landing page'!$K$17))*((MANAGER1[ADDITIONAL LANGUAGE 1]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 2]="english - Fluent")+(MANAGER1[ADDITIONAL LANGUAGE 3]="english - Fluent"))))

 

[Celticfc]

Figured out: I used an "," instead of "=" for my statements.