When you supply a range to ISNUMBER (i.e.
anarray), ISNUMBER will return an array of results.
Range contains numbers
To test a range for numbers, you can use a formula based on the ISNUMBER and SUMPRODUCT functions. In the example shown, the formula in G5 is: =SUMPRODUCT(--ISNUMBER(C5:C9))>0
