Excel formula to calculate revenue for given table assuming dynamic arrays are available

I have a table with below columns in Excel: Date, region, product, salesperson, units, Revenue. I need to build a formula that returns total revenue for selected region in cell H2, a selected product in cell H3, between start date in H4 and end date in H5. What Excel formula (no pivot table) would you use to compute this total revenue assuming dynamic arrays are available? I have tried using SUMIFS after converting the above columns into a table. But it's giving 0 even when there is some revenue value.

Would really appreciate any guidance on how to solve this question.

Thanks