| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formla
What is the formula for counting the number of cells containing ANY
text? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formla
=COUNTA(A1:A20)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Forgetfulpgk" wrote in message ... What is the formula for counting the number of cells containing ANY text? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formla
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" wrote in message ... =COUNTA(A1:A20) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Forgetfulpgk" wrote in message ... What is the formula for counting the number of cells containing ANY text? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formla
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" wrote in message ... 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" wrote in message ... =COUNTA(A1:A20) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Forgetfulpgk" wrote in message ... What is the formula for counting the number of cells containing ANY text? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formla
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... =COUNTA(A1:A20) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Forgetfulpgk" wrote in message ... What is the formula for counting the number of cells containing ANY text? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formla
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... =COUNTA(A1:A20) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Forgetfulpgk" wrote in message ... What is the formula for counting the number of cells containing ANY text? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
