You could dump the array to a worksheet range and then use that, but in
reality you just need to use the functions as designed. Just as you can't
pass a string to a function expecting a number and expect to get a
reasonable result, the same is true here.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kris_Wright_77" wrote in message
...
Thanks for the explanation, Bob.

Is there a way around the problem without resorting to a "loop" or
multiple
lines of similar code to see which numbers reoccur within the array?

Thanks for any more help that anyone can give.

Kris

"Bob Phillips" wrote:

That is because those 3 functions can work on an array of numbers,
COUNTIF
cannot, it needs a range as the first argument. To demonstrate this, try
this in Excel

=AVERAGE({1,2,3,4,5})

Then try

=COUNTIF({1,2,3,4,5},3)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)