You might incorporate an IF function, along the lines of
IF(ISNUMBER(your array function here),your array function here,0)

It seems redundant, but it evaluates the array function to determine if
it is numeric.