Month-to-Date sum

[rhyse]

Hi
Need some help here

I want to be able to find the sum of November 1 to the current day of the month (will automatically update based on what day it is today)

For example if today is 11 I want it to calculate the sum of the first 11 cells in column b which should return the value ($406,489.97)

if today is the the 13 i want it to calculate the sum of the first 13 cells in column b which should return the value ($432,186.95)

and so on

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="class: grid, width: 0"]
<tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"]November 2017[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]$68,984.28[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]$17,715.00[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]$2,380.00[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]$29,774.86[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]$149,187.94[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]$9,998.00[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]$9,384.05[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]$119,065.84[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]$25,696.98[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]$45,340.68[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]$6,681.05[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]$4,838.45[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"]$40,386.99[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]$146,016.49[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: center"]$202,543.70[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"]$1,600.00[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: center"]$50,823.58[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: center"]$24,879.85[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: center"]$12,747.39[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: center"]$24,600.07[/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]Deposits Total[/TD]
[TD="align: center"]$992,645.20[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Original post here: https://www.mrexcel.com/forum/excel-questions/1051386-sum-based-date.html

Look at #12 here: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[wideboydixon]

Is it just this?

=SUM($B$2:INDEX($B:$B,DAY(TODAY())+1))

WBD

 

[jtakw]

Is it just this?

=SUM($B$2:INDEX($B:$B,DAY(TODAY())+1))

WBD

Don't waste your time, it was already answered at the original thread.