ExcelBanter - Function - how to count all cells with text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Function - how to count all cells with text (https://www.excelbanter.com/excel-discussion-misc-queries/165652-function-how-count-all-cells-text.html)

Kathrine

Function - how to count all cells with text

How can I insert a function that only counts cells with text??

Ron Rosenfeld

Function - how to count all cells with text

On Mon, 12 Nov 2007 04:14:00 -0800, Kathrine
wrote:

How can I insert a function that only counts cells with text??

Something like:

=SUMPRODUCT(--(ISTEXT(A1:A10)))

--ron

RagDyeR

Function - how to count all cells with text

Another way:

=COUNTIF(A:A,"*?")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Kathrine" wrote in message
...
How can I insert a function that only counts cells with text??

Gord Dibben

Function - how to count all cells with text

=COUNTA(A2:A100)-COUNT(A2:A100)

Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 04:14:00 -0800, Kathrine
wrote:

How can I insert a function that only counts cells with text??

All times are GMT +1. The time now is 10:17 AM.