=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:

Please Login or Register  to view this content.

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

I then tried a COUNTA instead as follows:

Please Login or Register  to view this content.

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