Counting occurences of text

  • Thread starter Thread starter jc132568
  • Start date Start date
J

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
 
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)
 
Many thanks.
regards
Martina

Teethless mama said:
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)
Click to expand...
 
Back
Top