Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I want to sum two periods
Sum Highlighted in Green based on Start Date in G2 and End Date H2
Expected Result as below
I want Total Capacity Between Above two periods when I change the dates formula should be updated
Sum Highlighted in Green based on Start Date in G2 and End Date H2
Book3 | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
1 | Start Date | End Date | ||||||
2 | Start Date | End Date | Capacity | 10/12/2020 | 2/11/2021 | |||
3 | 7/12/2020 | 9/11/2020 | 0 | |||||
4 | 9/12/2020 | 10/11/2020 | 20 | |||||
5 | 10/12/2020 | 11/11/2020 | 40 | |||||
6 | 11/12/2020 | 12/11/2020 | 70 | |||||
7 | 12/12/2020 | 1/11/2021 | 90 | |||||
8 | 1/12/2021 | 2/11/2021 | 100 | |||||
9 | 2/12/2021 | 3/11/2021 | 100 | |||||
Sheet1 |
Expected Result as below
I want Total Capacity Between Above two periods when I change the dates formula should be updated
Book3 | ||||||||
---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | |||
1 | Expected Result | |||||||
2 | Start Date | End Date | ||||||
3 | Start Date | End Date | Capacity | 10/12/2020 | 2/11/2021 | |||
4 | 7/12/2020 | 9/11/2020 | 0 | 300 | ||||
5 | 9/12/2020 | 10/11/2020 | 20 | |||||
6 | 10/12/2020 | 11/11/2020 | 40 | |||||
7 | 11/12/2020 | 12/11/2020 | 70 | |||||
8 | 12/12/2020 | 1/11/2021 | 90 | |||||
9 | 1/12/2021 | 2/11/2021 | 100 | |||||
10 | 2/12/2021 | 3/11/2021 | 100 | |||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G4 | G4 | =SUM(E6:E9) |