counting text

[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

 

[T. Valko]

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.

 

[Bob I]

Find (CTRL+F) will return the number of cell containing the search term

 

[Mike H]

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.