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

(e-mail address removed) 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Loop 0
How to count the numbers in a Word document? 0
Section and Page numbering 0
Dcount -Date Criteria - Won´t find it - 0
Select Text to End of Footnote 9
How to display zero value in blank fields of Cross Tab query 0
Remove Identical words 0
Counting the Number of times the Slides are visited 0

Top