count

V

vernalGreens

=COUNT(1/ISNA(MATCH(A1,B:B,0))/(A1<>""))

I thought COUNT counts the numbers and number arguments. What is the
implication of / in COUNT?
 
H

Harlan Grove

[email protected] wrote...
=COUNT(1/ISNA(MATCH(A1,B:B,0))/(A1<>""))

I thought COUNT counts the numbers and number arguments. What is the
implication of / in COUNT?
Click to expand...

COUNT doesn't include error values. If A1 were "", the the last term
would be FALSE, but used as an operator to / the FALSE is converted to
zero, division by zero is an error, so COUNT won't include it.
Likewise, the ISNA term is FALSE if A1 appears in col B, again FALSE as
an operator to / is converted to zero, and division by zero is an
error, so COUNT won't include it.
 
Top