Dear sir,
I tried Sum Product which is Multiple Text and date Criteria and i did not get the correct answer. could you please correct this formula..

=SUMPRODUCT((C7:C450=X7)*((--$B$7:$B$450<=AC3)*(--($B$7:$B$450>=Z3))*(G7:G450=Z6)*(M7:M450)))..

B column is Date
C column is Name..
G column is Grade..
M column is Value..
I would like sum the M column..more important any two dates between the dates..