Sum totals across a range of dates

[HJHamm]

On the Data Sheet, each Project (Column A) has a start date (Column G) and an end date (Column H) with duration (Column I) and Revenue (Column J). There can be multiple Projects with the same name, but starting and ending on different dates
What I need to do is to create an Overview Sheet where management can look at the revenue stream by project over a 52 week range. And, I am totally befuddled

The Overview Sheet has the Projects in Column A and in row 1 are the dates for each Monday. So, say one of the ABC Projects starts on 6/15 and runs through 7/15 it has a Duration of 3.14 weeks with a total Revenue of $1,100. Therefore each week this specific ABC project is generating $350 per week. Now, let's say another ABC Project starts on 6/22 and runs through 7/22 I need to show this- when these two projects are running simultaneously the $ amount is $700 etc... Any help is greatly appreciated as I am terminally "stuck"

[stunn]

Try this (typed into B2, then copied across/down):

=SUMPRODUCT((Data!$A$2:$A$21=$A2)*(Data!$G$2:$G$21/Data!$F$2:$F$21)*(Data!$D$2:$D$21<=B$1)*(Data!$E$2:$E$21>=B$1))