HI,
I have two tables, one showing types of apartments with the number of appliances in each. At the end of the table the total discharge units associated with each apartment is added together.
<colgroup><col span="18"><col><col></colgroup><tbody>
</tbody>
The second table shows the drainage stacks with each type of apartment that is connected on each floor.
<colgroup><col span="18"><col><col span="5"><col></colgroup><tbody>
</tbody>
I have tried various vlookup commands to sum the DU in the total column, however as soon as I make the reference cell associated with another floor I get #N/A. If I keep the reference cell the same, so for the same floor, the formula sums correctly.
Any help would be very welcome.
Many thanks
I have two tables, one showing types of apartments with the number of appliances in each. At the end of the table the total discharge units associated with each apartment is added together.
Room Types | SHWR | Basin | WC | Sink | DW | WM | Total D/U | |||
DU(l/s) | 0.4 | 0.3 | 1.7 | 1.3 | 0.2 | 1.2 | ||||
Cluster | 1 | 1 | 1 | 2.4 | ||||||
Studio | 1 | 1 | 1 | 1 | 3.7 | |||||
Duplex | 1 | 1 | 1 | 1 | 3.7 | |||||
Penthouse | 1 | 1 | 1 | 1 | 3.7 | |||||
******* | 2 | 2 | 3.0 | |||||||
Laundry | 4 | 4.8 |
<colgroup><col span="18"><col><col></colgroup><tbody>
</tbody>
The second table shows the drainage stacks with each type of apartment that is connected on each floor.
Stack | UG | First | Second | Third | Fourth | Fifth | Sixth | Total D/U |
1AE | Cluster | Cluster | Cluster | Cluster | Cluster | Cluster | Duplex | 3.70 |
1AB | Cluster | Cluster | Cluster | Cluster | Cluster | Cluster | Studio | 4.80 |
1AC | Cluster | Cluster | Cluster | Cluster | Cluster | Cluster | Penthouse | #N/A |
1CC | Cluster | Cluster | Cluster | Cluster | Cluster | Penthouse | Penthouse | #N/A |
2AE | Cluster | Cluster | Cluster | Cluster | Cluster | Duplex | #N/A | |
2BB | Cluster | Cluster | Cluster | Cluster | Studio | Studio | #N/A | |
4BE | Studio | Studio | Studio | Studio | Studio | Duplex | #N/A | |
4BB | Studio | Studio | Studio | Studio | Studio | Studio | #N/A | |
4BC | - | Studio | Studio | Studio | Studio | Studio | Penthouse | #N/A |
5CC | ******* | ******* | ******* | ******* | ******* | Penthouse | Penthouse | 3.00 |
5DC | ******* | ******* | ******* | ******* | ******* | ******* | Penthouse | 3.00 |
6DD | - | ******* | ******* | ******* | ******* | ******* | ******* | #N/A |
6DB | - | ******* | ******* | ******* | ******* | ******* | Studio | #N/A |
1C | Cluster | Cluster | Cluster | Cluster | Cluster | Penthouse | - | 2.40 |
2C | - | Cluster | Cluster | Cluster | Cluster | Penthouse | - | #N/A |
3C | Cluster | ******* | Cluster | Cluster | Cluster | Penthouse | - | 2.40 |
6C | - | ******* | ******* | ******* | ******* | Penthouse | - | #N/A |
<colgroup><col span="18"><col><col span="5"><col></colgroup><tbody>
</tbody>
I have tried various vlookup commands to sum the DU in the total column, however as soon as I make the reference cell associated with another floor I get #N/A. If I keep the reference cell the same, so for the same floor, the formula sums correctly.
Any help would be very welcome.
Many thanks