Counting occurences of text

[jc132568]

Dear Experts,
I am trying to count the appearance of text in a cell. When I use COUNTA it
also counts the existence of the formula in the cell (which was used to
deliver the text of interest). How can I count only the textual result of
the formula?

=IF(G4=0,"",G4)

Alternatively how can I count non-zero entries, excel didn't like the
following:
=COUNTIF(G4:G63,<>0)
regards
Martina

 

[T. Valko]

To count cells that contain TEXT and exclude formula blanks:

=COUNTIF(A1:A10,"?*")

=COUNTIF(G4:G63,<>0)

Try it like this:

=COUNTIF(G4:G63,"<>0")

 

[Teethless mama]

This formula is ignored "0s" but included blank cells
=COUNTIF(G4:G63,"<>0")


These formula are ignored both "0s" and blank cells

=COUNTIF(G4:G63,">0")+COUNTIF(G4:G63,"<0")
or
=COUNT(G4:G63)-COUNTIF(G4:G63,0)

 

[jc132568]

Many thanks.
regards
Martina

This formula is ignored "0s" but included blank cells
=COUNTIF(G4:G63,"<>0")


These formula are ignored both "0s" and blank cells

=COUNTIF(G4:G63,">0")+COUNTIF(G4:G63,"<0")
or
=COUNT(G4:G63)-COUNTIF(G4:G63,0)