Thread: =Count(if( where the cell is text not a number

Hello,

In column C I have a list of Course Titles, stored as text. There are 50 rows.

In column L I want to display the number of times the value in that row's column C appears in the whole of column C.

I have tried the following array formula in L2:

{=COUNT(IF(C2=$C$2:$C$51,$C$2:$C$51,""))}

But because the values are stored as text, each row is counting 0.

I then tried a COUNTA instead as follows:

=COUNTA(IF(C2=$C$2:$C$62,$C$2:$C$62,""))

But that seems to be counting the whole of column C, not the number of occurrances.

Grateful for any pointers.

Thanks,

HE

Try: =COUNTIF($C$2:$C$62, C2) and pull down