Wrong. It compares *EACH* cell in A2:A26 to G1 and returns an
*ARRAY*
of TRUE/FALSE results. If you want to check whether ANY cell in A2:A26
equals G1 and return a SINGLE TRUE/FALSE result, use
COUNTIF($A$2:$A$26,G$1)0.

Wow, thanks guys for the fast response....
but how does a TRUE or FALSE result get translated into a NUMERIC VALUE
?
0=false 1=true ????
(I tried entering "=True()" into a cell and formatting it, but it did
not return a number)

If you notice, an array is then multiplied to another array....
I am assuming the number of multiplications is only equivalent to the
length of the vector, correct ?


--
msimms
------------------------------------------------------------------------
msimms's Profile: http://www.excelforum.com/member.php...o&userid=30382
View this thread: http://www.excelforum.com/showthread...hreadid=500441