remove #VALUE and #N/A from an Array

Hello,

I'm creating an array to pass to SomeFunction....but the function can only handle numbers and not items like #VALUE or #N/A.

Is there some way to strip out the #VALUE/#N/A's from the array and return everything else?

{=SomeFunction((Table1[Crit1]=1)*(Table1[Crit2]="B")*(Table1[Value]))}

Thanks,
Al

You can try {=SomeFunction(iferror((Table1[Crit1]=1)*(Table1[Crit2]="B")*(Table1[Value]),""))}