Count items with the same value

Hi Guys.

I Want to create a list with item that has the same value and I want to count how many item has the same value.

Is there a way to do this?

This is just an example.

 

 

 

Hi Bardur,

So you want to, for example, count how many rooms are in each department?

Kind regards,

David

Thank you both very much

That solv my problem