Sum if date ranged.

I am looking for help with an equation. I have tried a couple things and I have not been able to figure out a solution to what I need to calculate.


I am looking to make a data tracker of occurrences of events. I have a set of "raw" data that is imputed of all occurrences. They include Column A: Date, Column B: Name, Column C: number of occurrences at the event.

There can be multiple date name and occurrence combination (see attached excel file)



What I am looking to make is a new tab on he bottom that will have a summary and you can pick a date range.


What I have is the option to type the two dates in the top. I would like the chart below to adjust for the information that fits the date range.(see attached excel file)

I have tried several sum ifs but cannot get anything to work.

report demo.xlsx