G
Guest
How do we count cells containing text, excluding blank cells?
B
Bob Phillips
=COUNTA(D
)-COUNT(D)
)-COUNT(D)
R
RagDyeR
Try this:
=COUNTIF(A:A,"*?")
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How do we count cells containing text, excluding blank cells?
=COUNTIF(A:A,"*?")
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How do we count cells containing text, excluding blank cells?
H
Harlan Grove
RagDyeR wrote...
Given the internals of pattern processing, it'd be more efficient to
use =COUNTIF(A:A,"?*").
....
Given the internals of pattern processing, it'd be more efficient to
use =COUNTIF(A:A,"?*").
H
Harlan Grove
Bob Phillips wrote...
Picky: that'd include cells evaluating to errors and booleans in the
count. It'd also include cells evaluating to "".
....=COUNTA(D
Picky: that'd include cells evaluating to errors and booleans in the
count. It'd also include cells evaluating to "".