sajohnson05
New Member
- Joined
- Aug 21, 2013
- Messages
- 20
I have two tabs with a list of different sites. I am needing to get cost amounts based on the type of work and also a count of line items per system. Below i have shown what is on one tab and the other tab where i need sum and count. Any help would be great. Thanks
Tab 1
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Tab 1
Division | Site | System | Eqpt | Description | Item Code | Cost |
Star | Ville MC | Air Distribution | AHU01 -OIC | Smoke Detector is on unit but not being read by Metasys | AS | $485.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | Dampers do not have the same hysteresis | CM | $420.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | Bad OA humidity sensor | CM | $331.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | Exhaust damper actuator bad & damper stuck closed | CM | $1,012.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | Add low limits for proper coverage | CM | $838.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | Clean Air Flow rings and repair flex | FM | $280.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | Clean OSA intake grills | FM | $834.00 |
Star | Ville MC | Air Distribution | AHU01 -OIC | damper/valves with actuators that have feed back | AE | $4,388.00 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
# of line items per system | |||||||||||||||
Tab 2 | |||||||||||||||
Division | Site | Total CM | Total FM | Total Maintenance | Cost Total AS | Total AE | Total UL | Total AU | Grand Total | Air Distribution | CHW | HW |
<colgroup><col><col><col span="3"><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>