broncos347
Active Member
- Joined
- Feb 16, 2005
- Messages
- 291
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet with two workbooks as below
I am trying to find a way to provide a summary of the costs shown in column AD of the Business Plan for each period (Columns C to L of the Cost Summary sheet) and the description in C33 also shown in the Cost Summary.
Can anyone help?
| Book1 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | |||
| 32 | Period | 2016/17 | 2017/18 | 2018/19 | 2019/20 | 2020/21 | 2021/22 | 2022/23 | 2023/24 | 2024/25 | 2025/26 | ||
| 33 | 01 Building | ||||||||||||
Cost Summary | |||||||||||||
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| O | V | W | AC | AD | |||
| 2 | Rail Year | Delivery | Total | ||||
| 3 | Sub-total | Constr. | Sub-total | ||||
| 4 | 2019/20 | 36,450.00 | 250,000.00 | 337,500.00 | 373,950.00 | ||
Business Plan | |||||||
I am trying to find a way to provide a summary of the costs shown in column AD of the Business Plan for each period (Columns C to L of the Cost Summary sheet) and the description in C33 also shown in the Cost Summary.
Can anyone help?
