Sum row that match daterange with multiple conditions

[TrungVL]

My data looks like this:

I wanted to sum a range that match 3 conditions

1. Country
2. Sum data from DateRange >= Day1
and
3.DateRange <= Day2

Example: I like to sum a range from 27-7 to 29-7 that match SG

Tried index match for only one date and it worked, but for date range the formula keeps giving error.

 

[Marcelo Branco]

This worked as intended, thank you so much, I already thinks about sumifs but forget sumifs with match.

Thanks guy for helpingg me
Thread close

You are welcome. Thanks for the feedback.

M.