lookup value between dates

Hi all i need a lookup formula that would do the following i have the below table which is my source table

Then i have another sheet that looks like this Customer # from date to date Total Amount
A01 04/01/16 TO 04/30/17

I would like to get the total amount from my source table but only the total amounts that fit in those dates fro ex. (from 04/01/16 to 04/30/2017)

May be try

Formula:

=SUMIFS(C:C,B:B,">="&DATEVALUE(LEFT(M2,8)),B:B,"<="&DATEVALUE(RIGHT(M2,8)),A:A,L2)