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

Try, in C7, copied down and over to next column:

=SUMPRODUCT(--('raw data'!$B$2:$B$14=$B7),--('raw data'!$A$2:$A$14>=$E$2),--('raw data'!$A$2:$A$14<=$G$2),'raw data'!C$2:C$14)

or, post 2003 versions

=SUMIFS('raw data'!C$2:C$14,'raw data'!$B$2:$B$14,$B7,'raw data'!$A$2:$A$14,">="&$E$2,'raw data'!$A$2:$A$14,"<="&$G$2)