Thanks Harlan! My apologies. I forgot to test it. It looks like INDEX
will not accept the array, in either case. Any ideas?

In article .com,
"Harlan Grove" wrote:

Domenic wrote...
...
=IF(COUNTIF(Array,"=-9.99999999999999E+307"),N(Array),T(Array))
...

It's a pain that COUNTIF and SUMIF are the only functions that can
work directly with arrays of range references, but it's easier to test
that something's not text. Try

=IF(COUNTIF(Array,"<*"),N(Array),T(Array))