C
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)
but it didnt work
=COUNTIF(A:A,isnumber)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ragdyer
=COUNT(A: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
=COUNTA(A1:A10) will count all values in A1:A10.
************
Anne Troy
www.OfficeArticles.com
D
Don Guillett
Don't use this but it works
=COUNT(IF(ISNUMBER(A:A),A:A))
=COUNT(IF(ISNUMBER(A:A),A:A))
R
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.
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.
P
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)
=COUNT(FALSE)
and since FALSE equals zero it counts
=COUNT(0)
which is 1
--
Regards,
Peo Sjoblom
(No private emails please)
R
Ragdyer
I was wrong!
I never knew that answer before.
Thanks Peo.
I never knew that answer before.
Thanks Peo.
D
Don Guillett
I'm glad Peo answered cuz I didn't know either.
H
Harlan Grove
Don Guillett said: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.