# Sum of values INCLUDING Start & End Dates

#### hsandeep

##### Well-known Member
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.

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>

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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>

maybe something like...

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

Thanks Weazel, It WORKS.

you're welcome

Replies
0
Views
250
Replies
8
Views
179
Replies
2
Views
440
Replies
11
Views
2K
Replies
11
Views
894

1,218,656
Messages
6,143,731
Members
450,502
Latest member
sakaria_123

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back