counting text

  • Thread starter Thread starter mariekek5
  • Start date Start date
M

mariekek5

Hi,

Is it possible to count the amount of cells with a specific text?

For instance, if I have three cells with the code 'RTT', is it possible to
count that there are three cells containing 'RTT'?

Thanks a lot in advance!

Marieke
 
Try it like this...

=COUNTIF(A1:A10,"RTT")

Or, use a cell to hold the criteria:

C1 = RTT

=COUNTIF(A1:A10,C1)

Adjust the range to suit.
 
Hi,

Like this maybe

=COUNTIF(A1:A10,"rtt")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top