Formula to sum only if date is greater than required date

[asad]

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.

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

 

[asad]

I can achieve the answer using this formula

=LOOKUP(A20,$A$1:$A$2,$B$1:$B$2)+LOOKUP(A20,$A$1:$A$2,$C$1:$C$2)

but as the formula is going to be used in a large range, I was hoping that someone will be able to give me a better solution.

 

[asad]

Any suggestions?

 

[asad]

Finally worked out a formula

SUM(IF($A$1:$A$2=LARGE(IF($A$1:$A$2<=A6,$A$1:$A$2),1),$B$1:$C$2,0))

entered with ctrl+shift+enter