Sum of values INCLUDING Start & End Dates

[hsandeep]

B2:B9999=Date & C2:C9999=Values
E2:E9999=Start Date & F2:F9999=End Date
Output required G2:G9999 as total of C column INCLUDING Start Date’s Value & End Date’s Value.

How to accomplish?
I am using Excel 2007.
Thanks in advance.

Sheet1

	B	C	D	E	F	G
2	1-Jan-2016	10		1-Feb-2016	29-Feb-2016	110
3	11-Jan-2016	20		1-Jan-2016	14-Feb-2016	130
4	25-Jan-2016	50
5	1-Feb-2016	20
6	14-Feb-2016	30
7	29-Feb-2016	60

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 82px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 77px"><col style="WIDTH: 82px"><col style="WIDTH: 78px"></colgroup><tbody>
</tbody>

 

[Weazel]

maybe something like...

G2=SUMIFS($C$2:$C$9999,$B$2:$B$9999,">="&E2,$B$2:$B$9999,"<="&F2)

Row\Col	B​	C​	D​	E​	F​	G​
1​	B	C	D	E	F	G
2​	1-Jan-16​	10​		1-Feb-16​	29-Feb-16​	110​
3​	11-Jan-16​	20​		1-Jan-16​	14-Feb-16​	130​
4​	25-Jan-16​	50​
5​	1-Feb-16​	20​
6​	14-Feb-16​	30​
7​	29-Feb-16​	60​

<tbody>
</tbody>

 

[hsandeep]

maybe something like...

G2=SUMIFS($C$2:$C$9999,$B$2:$B$9999,">="&E2,$B$2:$B$9999,"<="&F2)

Thanks Weazel, It WORKS.

 

[Weazel]

you're welcome