DavidPonnet
New Member
- Joined
- Mar 16, 2017
- Messages
- 23
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 (so part of the information.) R01 / R02 etc
Would it be possible to easily make such a formula ? (I need to have the sum of different columns)
<tbody>
</tbody>
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 (so part of the information.) R01 / R02 etc
Would it be possible to easily make such a formula ? (I need to have the sum of different columns)
R01-V01 | 5000 € | 250 h | 100 h | ||
R01-V02 | 7500 € | 300 h | 125 h | ||
R02-V01 | 1200 € | 100 h | 50 h | ||
R02-V02 | 1500 € | 125 h | 60 h | ||
R02-V03 | 2500 € | 180 h | 100 h |
<tbody>
</tbody>