Hi, I want to count the number of cells at col. A that contain number only,
but it didnt work
=COUNTIF(A:A,isnumber)
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
[email protected]
"crapit" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Don't use this but it works
> =COUNT(IF(ISNUMBER(A:A),A:A))
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "crapit" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:Ot%[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
>> Don't use this but it works
>> =COUNT(IF(ISNUMBER(A:A),A:A))
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "crapit" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:Ot%[email protected]...
> >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" <[email protected]> wrote in message
> > news:[email protected]...
> >> Don't use this but it works
> >> =COUNT(IF(ISNUMBER(A:A),A:A))
> >>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> [email protected]
> >> "crapit" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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
[email protected]
"Ragdyer" <[email protected]> wrote in message
news:eSK7%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:Ot%[email protected]...
> > >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" <[email protected]> wrote in message
> > > news:[email protected]...
> > >> Don't use this but it works
> > >> =COUNT(IF(ISNUMBER(A:A),A:A))
> > >>
> > >> --
> > >> Don Guillett
> > >> SalesAid Software
> > >> [email protected]
> > >> "crapit" <[email protected]> wrote in message
> > >> news:[email protected]...
> > >> > 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" <[email protected]> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks