|
Excel formla
What is the formula for counting the number of cells containing ANY
text? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 03:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com