Sumproduct Query with "{ }"

[mart_mrexcel]

Why iam getting #N/A error in my formula IF I put more than 2 criteria in "{}"?

SUMPRODUCT((WageReporter_CC=A5)*(WageReporter_EmpType={"A","C"})*(WageReporter_ManpowerCateg={"A1","A2","C1"})*(WageReporter_Code={1007,1006})*(WageReporter_Amount)

 

[njimack]

Try replacing this:
WageReporter_ManpowerCateg={"A1","A2","C1"}
with this:
ISNUMBER(MATCH(WageReporter_ManpowerCateg,={"A1","A2","C1"},0))

 

[mart_mrexcel]

Try replacing this:
WageReporter_ManpowerCateg={"A1","A2","C1"}
with this:
ISNUMBER(MATCH(WageReporter_ManpowerCateg,={"A1","A2","C1"},0))

I'm getting an error might because of the "," before the "=", but when I removed it, its still giving me #N/A

 

[njimack]

I'm getting an error might because of the "," before the "=", but when I removed it, its still giving me #N/A

My bad - leave the comma but remove =
ISNUMBER(MATCH(WageReporter_ManpowerCateg,{"A1","A2","C1"},0))

 

[mart_mrexcel]

My bad - leave the comma but remove =
ISNUMBER(MATCH(WageReporter_ManpowerCateg,{"A1","A2","C1"},0))

That works great, thanks njimack