on cell f7 on ISBS sheet i want to put a formula that will give me the sum of column D if the year and month is same on cell f5 and cell F6 of ISBS sheet
Excel 2013/2016
F | |
---|---|
2 | |
3 | |
4 | |
5 | 2018 |
6 | January |
7 | |
<tbody>
</tbody>
IS BS
Excel 2013/2016
B | C | D | |
---|---|---|---|
16 | date | 17-Oct Acquisition useful life 60 months | Total Machineries Depreciation |
17 | 10/30/2017 | 12,143.46 | 12,143.46 |
18 | 11/30/2017 | 12,143.46 | 12,143.46 |
19 | 12/30/2017 | 12,143.46 | 12,143.46 |
20 | 01/30/2018 | 12,143.46 | 12,143.46 |
21 | 02/28/2018 | 12,143.46 | 12,143.46 |
22 | 03/30/2018 | 12,143.46 | 12,143.46 |
23 | 04/30/2018 | 12,143.46 | 12,143.46 |
24 | 05/30/2018 | 12,143.46 | 12,143.46 |
25 | 06/30/2018 | 12,143.46 | 12,143.46 |
26 | 07/30/2018 | 12,143.46 | 12,143.46 |
27 | 08/30/2018 | 12,143.46 | 12,143.46 |
28 | 09/30/2018 | 12,143.46 | 12,143.46 |
29 | 10/30/2018 | 12,143.46 | 12,143.46 |
30 | 11/30/2018 | 12,143.46 | 12,143.46 |
31 | 12/30/2018 | 12,143.46 | 12,143.46 |
32 | 01/30/2019 | 12,143.46 | 12,143.46 |
<tbody>
</tbody>
Lapsing Schedule
Last edited: