Hi all

I need to count data that sometimes includes #VALUE! and cannot work it out

This is what I am using but now and again the data includes #VALUE and due
to tha amount of lookups I cannot ommit this from the data that is been
counted

{=SUM(($M$1:$M$357=$B400)*($F$1:$F$357=0.02))}


any help much apprieciated

Nelly