Date Range Formula Help

[missdeannamarie]

Hello, I am looking for a formula that will look at the dates in two columns, and return the sum of another column if those dates are included in a certain month.

For example below. The first table, is where my data is stored. The second table, I want to return the sum of resources needed if the two columns date ranges include that month. So for October in the second table, it would return 2 while November returns 3.

Hope that makes sense and that someone can help me out!

[TABLE="width: 500"]
<tbody>[TR]
[TD]PLANNED APPLICATION ENGINEERS[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD]START DATE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 57"]
<tbody>[TR]
[TD]END DATE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/22/18[/TD]
[TD]3/10/19[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]11/5/18[/TD]
[TD]4/1/19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]OCTOBER 18[/TD]
[TD]NOVEMBER 18[/TD]
[TD]DECEMBER 18[/TD]
[TD]JANUARY 19[/TD]
[/TR]
[TR]
[TD]TOTAL APPLICATION ENGINEERS NEEDED[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[missdeannamarie]

Hoping to get some help on this! Here is some more info.

I have the data on two sheets.

The first sheet we'll call raw data, the date ranges are in H:I, and I want G summed if the date range includes a certain month.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Planned Resources[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]10/22/18[/TD]
[TD]3/10/19[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]11/5/18[/TD]
[TD]4/1/19[/TD]
[/TR]
</tbody>[/TABLE]


The second sheet we'll call calculation, i want cells (B2) to return 2 and (C2) to return 3 based on the start and end dates in the other sheet.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]Oct 2018[/TD]
[TD]Nov 2018[/TD]
[TD]Dec 2018[/TD]
[TD]Jan 19[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TOTAL APPLICATIONS RESOURCES NEEDED[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have tried this but am getting a return of 0

any ideas out there?

=SUMPRODUCT((MONTH('Raw Data'!H3:H4)<=MONTH(Calculation!C1))*(YEAR('Raw Data'!H3:H4)<=YEAR(Calculation!C1))*(MONTH('Raw Data'!I3:I4)>=MONTH(Calculation!C1))*(YEAR('Raw Data'!I3:I4)>=YEAR(Calculation!C1))*'Raw Data'!G3:G4)