Help with a COUNTIF (I think)
Hello, all:
I have a column of about 500 cells, some of which contain numbers, some
contain blanks, and some contain the word "none". I want to put a formula in
the cell at the top of the colum which counts ONLY those cells which contain
numbers.
Is there a specific function which will recognize only numbers? Failing
that, I assume a COUNTIF is in order.
I tried this:
=COUNTIF(A2:A500,AND("<""","<none"))
but it yields a zero. I've also tried variations moving around and
eliminating the double quotes but I can't get it to work.
Any suggestions? Help is appreciated. Thanks,
MARTY
|