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

=sumproduct(--isnumber(a2:a500))

"Marty" wrote in message
...
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

Didn't work. Still yields a zero.

I assume you intended me to replace the "--" with the A2:A500 range.

Also, not sure why you're suggesting the use of SUMPRODUCT, since all I want
to do is count the cells.

What am I missing? Please say more.

"N Harkawat" wrote:

=sumproduct(--isnumber(a2:a500))

"Marty" wrote in message
...
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

No do not replace "--"

just copy the formula offered and paste it as it is...

=sumproduct(--isnumber(a2:a500))

IT WILL WORK.





"Marty" wrote in message
...
Didn't work. Still yields a zero.

I assume you intended me to replace the "--" with the A2:A500 range.

Also, not sure why you're suggesting the use of SUMPRODUCT, since all I
want
to do is count the cells.

What am I missing? Please say more.

"N Harkawat" wrote:

=sumproduct(--isnumber(a2:a500))

"Marty" wrote in message
...
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

Take a look at

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"Marty" wrote:

Didn't work. Still yields a zero.

I assume you intended me to replace the "--" with the A2:A500 range.

Also, not sure why you're suggesting the use of SUMPRODUCT, since all I want
to do is count the cells.

What am I missing? Please say more.

It worked! Thanks very much.

"N Harkawat" wrote:

No do not replace "--"

just copy the formula offered and paste it as it is...

=sumproduct(--isnumber(a2:a500))

IT WILL WORK.





"Marty" wrote in message
...
Didn't work. Still yields a zero.

I assume you intended me to replace the "--" with the A2:A500 range.

Also, not sure why you're suggesting the use of SUMPRODUCT, since all I
want
to do is count the cells.

What am I missing? Please say more.

"N Harkawat" wrote:

=sumproduct(--isnumber(a2:a500))

"Marty" wrote in message
...
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