Hello All,
The title is not explaining what I am looking for exactly. Okay, here it is. I have the following two dates with next two columns having the numbers to be summed.
Now in a separate range, I have a list of dates like from 01/07/2020 to 20/07/2020. I want to see the sum of columns B and C against those dates only if the date is more than or equal to the date above. But if the date is more than or equal to larger date, then ignore the sum for earlier date.
So, the sum I want for 01/07/2020 to 14/07/2020 is 12 and 15/07/2020 onwards, I want 14 not 26.
How can I do this?
Thanks
Asad
The title is not explaining what I am looking for exactly. Okay, here it is. I have the following two dates with next two columns having the numbers to be summed.
1/07/2020 | 10 | 2 |
15/07/2020 | 11 | 3 |
Now in a separate range, I have a list of dates like from 01/07/2020 to 20/07/2020. I want to see the sum of columns B and C against those dates only if the date is more than or equal to the date above. But if the date is more than or equal to larger date, then ignore the sum for earlier date.
So, the sum I want for 01/07/2020 to 14/07/2020 is 12 and 15/07/2020 onwards, I want 14 not 26.
How can I do this?
Thanks
Asad