I have a row that lists numbers between 2019 and 2045. I am starting a project on a specific year and ending on a specific year. As an example, if I start the project in 2020 and I am going to install 100 units a year for 4 years. I want the cell below it to reflect the total number of units installed. For example: 2020 total would be 100, 2021 would be 200, 2022 would be 300, and 2023 would be 400.
It should look like this and be Dynamic so if I change the dates it will count the cells that apply.
I have cross posted this message on ExcelForum
www.excelforum.com/excel-general/1225071-counting-total-number-of-units-installed.html#post4869069
It should look like this and be Dynamic so if I change the dates it will count the cells that apply.
I have cross posted this message on ExcelForum
www.excelforum.com/excel-general/1225071-counting-total-number-of-units-installed.html#post4869069
