i need a excel expert

we deal in mobile phones a (X) brand gives us various scheme on sales of its different models and end of the month we have prepare a excel for credit notes they give us incentive on sale of different models on different dates suppose (a,b,c,d) are models if i sell these models between 1-10-2022 to 5-10-2022 i get rs (200,400,600,800) respectively and on same models (c,d) i get (100,200) extra if sold between 3-10-2022 to 5-10-2022 so i want a formula to count the credit notes on subjective models or total of scheme refernce and every scheme has refernce number too. for your refernce i am attaching a excel with two workbooks in it one is for scheme and other is for model sold on different dates