=COUNTIF(A:A,isnumber) cant work

[crapit]

Hi, I want to count the number of cells at col. A that contain number only,
but it didnt work
=COUNTIF(A:A,isnumber)

 

[Ragdyer]

=COUNT(A:A)

 

[Anne Troy]

=COUNT(A1:A10) will count only the numeric values in A1:A10.
=COUNTA(A1:A10) will count all values in A1:A10.
************
Anne Troy
www.OfficeArticles.com

 

[Don Guillett]

Don't use this but it works
=COUNT(IF(ISNUMBER(A:A),A:A))

 

[Ragdyer]

I feel I knew the answer to this at one time, but ... why does your formula,
in a brand new empty sheet, with a virgin Column A, return a value of 1?

You enter a number into A, and it still returns 1.
You enter another number, and it returns 2.
Delete them both, and we're back to 1.

 

[Peo Sjoblom]

Because if no numbers are entered the formula returns

=COUNT(FALSE)

and since FALSE equals zero it counts

=COUNT(0)

which is 1


--
Regards,

Peo Sjoblom

(No private emails please)

 

[Ragdyer]

I was wrong!

I never knew that answer before.

Thanks Peo.

 

[Don Guillett]

I'm glad Peo answered cuz I didn't know either.

 

[Harlan Grove]

I'm glad Peo answered cuz I didn't know either.

Though you gotta wonder why COUNT can convert TRUE/FALSE to 1/0 but
SUMPRODUCT can't.