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>

Month	November 2017
1	$68,984.28
2	$17,715.00
3	$2,380.00
4	$0.00
5	$0.00
6	$29,774.86
7	$149,187.94
8	$9,998.00
9	$9,384.05
10	$119,065.84
11	$0.00
12	$0.00
13	$25,696.98
14	$45,340.68
15	$6,681.05
16	$4,838.45
17	$40,386.99
18	$0.00
19	$0.00
20	$146,016.49
21	$202,543.70
22	$1,600.00
23	$0.00
24	$0.00
25	$0.00
26	$0.00
27	$50,823.58
28	$24,879.85
29	$12,747.39
30	$24,600.07
31	-
Deposits Total

<colgroup><col style="width: 100px"><col width="109"></colgroup><tbody>
</tbody>

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