selecting data from a column with multiple conditions
 

Hi

I am looking for a VBA Code to select ascii data instead of numeric
with multiple conditions

a= = Evaluate("SUMPRODUCT(--(data!$A$2:$A$65536=B3),--(data!$b$2:$b
$65536=B4),--(data!$D$2:$D$65536=B12),(data!$k$2:$k$65536))")

This works fine if the data in the K column is numbers; but if it is
characters then a = zero

anyone got an idea?

Thanks in advance

Kurt