counting text
 

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

counting text
 

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.

--
Biff
Microsoft Excel MVP


"mariekek5" wrote in message
...
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

counting text
 

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

mariekek5 wrote:

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

counting text
 

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.


"mariekek5" wrote:

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