Countif with multiple values in a cell, separated by alt+enter (each their own line)

I've just been presented with a headach and nightmare.

I've to generate a proposal for a system security setup and the excel sheet I have been given contains values like this:

US.SSCMonitoring

07 May 2013 19:46:03

NA Admin NA Office Agent NA Supervisor NA Supervisor Admin

Manager

I do need to perform a count to see how many users have been assigned to the values in third column. This is only an example for one row I have 672 of these with different or no value in the 3rd column.

is there a 'simple' way to count these values or do I have to rework the file and separate the values out to different columns?

So far I have found that 4 values in the third column seems to be the maximum.

Thanks for your support!

Try this:

Formula:

Please Login or Register  to view this content.

Hi Zbor and benishiryo,

Thank you both so much for the quick reply. It's not quite what I was after.
What I am looking for is a count per different value.

like countif(range,value)

Can you upload example workbook with your input and desired output?
Make sure to avoid all private infromations

I've attached an extract of the part I struggle with

Everything in D684 to D723 is mockup and the output I expect is a break down per entry in C684 to C723 column

Thanks for your help