What is the formula for counting the number of cells containing ANY
text?
What is the formula for counting the number of cells containing ANY
text?
=COUNTA(A1:A20)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Forgetfulpgk" <[email protected]> wrote in message
news:[email protected]...
> What is the formula for counting the number of cells containing ANY
> text?
Interpretation is questionable here concerning the exact meaning of "text".
COUNTA() counts *non-empty* cells ... including numbers, errors (#DIV/0!),
logical values (TRUE, FALSE) and zero length strings ( "" ).
To count *only* text ... including alpha and numeric *text*, try this:
=COUNTIF(A1:A20,"*?")
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =COUNTA(A1:A20)
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Forgetfulpgk" <[email protected]> wrote in message
> news:[email protected]...
>> What is the formula for counting the number of cells containing ANY
>> text?
>
>
I agree, but isn't it always. I picked up specifically on the ANY.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"RagDyer" <[email protected]> wrote in message
news:%[email protected]...
> Interpretation is questionable here concerning the exact meaning of
"text".
>
> COUNTA() counts *non-empty* cells ... including numbers, errors (#DIV/0!),
> logical values (TRUE, FALSE) and zero length strings ( "" ).
>
> To count *only* text ... including alpha and numeric *text*, try this:
>
> =COUNTIF(A1:A20,"*?")
>
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > =COUNTA(A1:A20)
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Forgetfulpgk" <[email protected]> wrote in message
> > news:[email protected]...
> >> What is the formula for counting the number of cells containing ANY
> >> text?
> >
> >
>
And, as is normal around here, we'll never know without the OP's response
.... but ... it does enliven the thread *and* enlighten the archives.<bg>
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
I agree, but isn't it always. I picked up specifically on the ANY.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"RagDyer" <[email protected]> wrote in message
news:%[email protected]...
> Interpretation is questionable here concerning the exact meaning of
"text".
>
> COUNTA() counts *non-empty* cells ... including numbers, errors (#DIV/0!),
> logical values (TRUE, FALSE) and zero length strings ( "" ).
>
> To count *only* text ... including alpha and numeric *text*, try this:
>
> =COUNTIF(A1:A20,"*?")
>
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > =COUNTA(A1:A20)
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Forgetfulpgk" <[email protected]> wrote in message
> > news:[email protected]...
> >> What is the formula for counting the number of cells containing ANY
> >> text?
> >
> >
>
I agree, that is why there is no reason to assume a 'correct' response is
the final response (even if the OP says it is <G>).
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"RagDyeR" <[email protected]> wrote in message
news:[email protected]...
> And, as is normal around here, we'll never know without the OP's response
> ... but ... it does enliven the thread *and* enlighten the archives.<bg>
> --
>
> Regards,
>
> RD
> --------------------------------------------------------------------------
--
> -------------------
> Please keep all correspondence within the Group, so all may benefit !
> --------------------------------------------------------------------------
--
> -------------------
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> I agree, but isn't it always. I picked up specifically on the ANY.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "RagDyer" <[email protected]> wrote in message
> news:%[email protected]...
> > Interpretation is questionable here concerning the exact meaning of
> "text".
> >
> > COUNTA() counts *non-empty* cells ... including numbers, errors
(#DIV/0!),
> > logical values (TRUE, FALSE) and zero length strings ( "" ).
> >
> > To count *only* text ... including alpha and numeric *text*, try this:
> >
> > =COUNTIF(A1:A20,"*?")
> >
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
> -
> > "Bob Phillips" <[email protected]> wrote in message
> > news:[email protected]...
> > > =COUNTA(A1:A20)
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (replace somewhere in email address with gmail if mailing direct)
> > >
> > > "Forgetfulpgk" <[email protected]> wrote in
message
> > > news:[email protected]...
> > >> What is the formula for counting the number of cells containing
ANY
> > >> text?
> > >
> > >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks