Hello,
I will try to explain the following problem as good as possible.
In the first column, there is the name of a room combined with the number to a case (fe. R01-V02 / R05-V01 etc )
Sometimes more then 1 case per room.
I would like to make totals for each room, based on the room number...