hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
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
<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>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1-Jan-2016[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1-Feb-2016[/TD]
[TD="align: right"]29-Feb-2016[/TD]
[TD="align: right"]110[/TD]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]11-Jan-2016[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1-Jan-2016[/TD]
[TD="align: right"]14-Feb-2016[/TD]
[TD="align: right"]130[/TD]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]25-Jan-2016[/TD]
[TD="align: right"]50[/TD]
[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]1-Feb-2016[/TD]
[TD="align: right"]20[/TD]
[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]14-Feb-2016[/TD]
[TD="align: right"]30[/TD]
[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]29-Feb-2016[/TD]
[TD="align: right"]60[/TD]
</tbody>
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 | |
<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>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1-Jan-2016[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1-Feb-2016[/TD]
[TD="align: right"]29-Feb-2016[/TD]
[TD="align: right"]110[/TD]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]11-Jan-2016[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1-Jan-2016[/TD]
[TD="align: right"]14-Feb-2016[/TD]
[TD="align: right"]130[/TD]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]25-Jan-2016[/TD]
[TD="align: right"]50[/TD]
[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]1-Feb-2016[/TD]
[TD="align: right"]20[/TD]
[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]14-Feb-2016[/TD]
[TD="align: right"]30[/TD]
[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]29-Feb-2016[/TD]
[TD="align: right"]60[/TD]
</tbody>