Hi

I'm trying to do an advanced lookup that matches 3 criterias
so, i though i could use SUMPRODUCT

but the formula
=--(SUMPRODUCT((Ref!CX2:CX1069=Prog!J5)*(Ref!CY2:CY10 69=Prog!K5)*(Ref!DA2:DA1069=Prog!M5)*(Ref!DB2:DB10 69)))

returns a #VALUE!

the "calc steps" shows that the problem occurs prior the last calculation

column DB contains text and numbers
and i want/need to show that way


any ideas??