Sum based on Date

[rhyse]

Hi
Need some help here

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

It should total $406,489.97

And then say tomorrow when I check it should total to $432,186.95

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="109"></colgroup><tbody>[TR]
[TD="align: center"]Month[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , 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="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5ABC89]#5ABC89[/URL] , align: center"][/TD]
[/TR]
</tbody>[/TABLE]


Any help would be much appreciated have been struggling with this for a while!

Thanks!

 

[PhilS2520]

Hi rhyse

look into the SUMIF() Function. It states that you want to sum a range if a certain criteria (date) is met. Hope this helps.

 

[rhyse]

For example if today is 11 I want it to calculate the sum of the first 11 cells in column b
if today is the the 12 i want it to calculate the sum of the first 12 cells in column b
and so on

 

[jtakw]

Hi again,

Since you're using Today's date as the criteria, I've changed your sample to April of 2018:

Excel 2010
	A	B	C	D
1	Day	Apr-18		Result
2	1	$68,984.28		$406,489.97
3	2	$17,715.00
4	3	$2,380.00
5	4	$0.00
6	5	$0.00
7	6	$29,774.86
8	7	$149,187.94
9	8	$9,998.00
10	9	$9,384.05
11	10	$119,065.84
12	11	$0.00
13	12	$0.00
14	13	$25,696.98
15	14	$45,340.68
16	15	$6,681.05
17	16	$4,838.45
18	17	$40,386.99
19	18	$0.00
20	19	$0.00
21	20	$146,016.49
22	21	$202,543.70
23	22	$1,600.00
24	23	$0.00
25	24	$0.00
26	25	$0.00
27	26	$0.00
28	27	$50,823.58
29	28	$24,879.85
30	29	$12,747.39
31	30	$24,600.07
Sheet6

Cell Formulas
Range	Formula
D2	=SUMIF(A2:A31,"<="&DAY(TODAY()),B2:B31)

 

[rhyse]

Thanks jtakw

Solved my problems!!

 

[jtakw]

Posted again here: https://www.mrexcel.com/forum/excel-questions/1051388-month-date-sum.html

Forum rules here (#12): https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html