Sales per week by region

morning,

please could someome show me how to calculate the total number of sales made between two dates attributable to a specific region in cell H4 on the attached workbook?

thank you

use this formula in J4

=SUMPRODUCT(--($B$3:$B$27>=$J$2),--($B$3:$B$27<=$J$3),--($D$3:$D$27=$D3),($C$3:$C$27))

and copy paste on J5