=COUNTIF(A:A,isnumber) cant work

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

=COUNT(A:A)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
> Hi, I want to count the number of cells at col. A that contain number
only,
> but it didnt work
> =COUNTIF(A:A,isnumber)
>
>

=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

"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
> Hi, I want to count the number of cells at col. A that contain number
> only, but it didnt work
> =COUNTIF(A:A,isnumber)
>
>

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
> Hi, I want to count the number of cells at col. A that contain number
only,
> but it didnt work
> =COUNTIF(A:A,isnumber)
>
>

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.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" <donaldb@281.com> wrote in message
news:eM1q9zW3FHA.3880@TK2MSFTNGP12.phx.gbl...
> Don't use this but it works
> =COUNT(IF(ISNUMBER(A:A),A:A))
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "crapit" <littlecramP@yahoo.com.sg> wrote in message
> news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
> > Hi, I want to count the number of cells at col. A that contain number
> only,
> > but it didnt work
> > =COUNTIF(A:A,isnumber)
> >
> >
>
>

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" <RagDyer@cutoutmsn.com> wrote in message
news:Ot%233HFX3FHA.128@tk2msftngp13.phx.gbl...
>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.
>
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Don Guillett" <donaldb@281.com> wrote in message
> news:eM1q9zW3FHA.3880@TK2MSFTNGP12.phx.gbl...
>> Don't use this but it works
>> =COUNT(IF(ISNUMBER(A:A),A:A))
>>
>> --
>> Don Guillett
>> SalesAid Software
>> donaldb@281.com
>> "crapit" <littlecramP@yahoo.com.sg> wrote in message
>> news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
>> > Hi, I want to count the number of cells at col. A that contain number
>> only,
>> > but it didnt work
>> > =COUNTIF(A:A,isnumber)
>> >
>> >
>>
>>
>

I was wrong!

I never knew that answer before.

Thanks Peo.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:Osf38NX3FHA.1140@tk2msftngp13.phx.gbl...
> 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" <RagDyer@cutoutmsn.com> wrote in message
> news:Ot%233HFX3FHA.128@tk2msftngp13.phx.gbl...
> >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.
> >
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "Don Guillett" <donaldb@281.com> wrote in message
> > news:eM1q9zW3FHA.3880@TK2MSFTNGP12.phx.gbl...
> >> Don't use this but it works
> >> =COUNT(IF(ISNUMBER(A:A),A:A))
> >>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> donaldb@281.com
> >> "crapit" <littlecramP@yahoo.com.sg> wrote in message
> >> news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
> >> > Hi, I want to count the number of cells at col. A that contain number
> >> only,
> >> > but it didnt work
> >> > =COUNTIF(A:A,isnumber)
> >> >
> >> >
> >>
> >>
> >
>

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:eSK7%23gX3FHA.3976@TK2MSFTNGP15.phx.gbl...
> I was wrong!
>
> I never knew that answer before.
>
> Thanks Peo.
>
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Peo Sjoblom" <terre08@mvps.org> wrote in message
> news:Osf38NX3FHA.1140@tk2msftngp13.phx.gbl...
> > 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" <RagDyer@cutoutmsn.com> wrote in message
> > news:Ot%233HFX3FHA.128@tk2msftngp13.phx.gbl...
> > >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.
> > >
> > > --
> > > Regards,
> > >
> > > RD
> > >
> >
>
> --------------------------------------------------------------------------
> -
> > > Please keep all correspondence within the NewsGroup, so all may
benefit
> !
> >
>
> --------------------------------------------------------------------------
> -
> > > "Don Guillett" <donaldb@281.com> wrote in message
> > > news:eM1q9zW3FHA.3880@TK2MSFTNGP12.phx.gbl...
> > >> Don't use this but it works
> > >> =COUNT(IF(ISNUMBER(A:A),A:A))
> > >>
> > >> --
> > >> Don Guillett
> > >> SalesAid Software
> > >> donaldb@281.com
> > >> "crapit" <littlecramP@yahoo.com.sg> wrote in message
> > >> news:eycWWEW3FHA.1416@TK2MSFTNGP09.phx.gbl...
> > >> > Hi, I want to count the number of cells at col. A that contain
number
> > >> only,
> > >> > but it didnt work
> > >> > =COUNTIF(A:A,isnumber)
> > >> >
> > >> >
> > >>
> > >>
> > >
> >
>

"Don Guillett" <donaldb@281.com> wrote...
>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.