Sum MTD and YTD formulas

[sachavez]

Excel 2010

Looking for some help on two formulas:

Sum MTD units
Sum YTD units

Column A contains dates
Column B contains units

Date data starts in cell A3
Unit data starts in cell B3

MTD formula will be in cell A1
YTD formula will be in cell B1

Data set grows daily, but it's at "table" so I ***think*** the formula would be dynamic?

Thanks in advance!

Steve

 

[sheetspread]

Try this:

Excel 2010
	A	B	C	D
1
2	Date	Number
3	9/3/2013	3
4	10/3/2013	3
5	11/2/2013	4
6	11/22/2013	2
7	1/1/2014	11
8	1/31/2014	5
9	3/2/2014	5
10	4/1/2014	8
11	5/1/2014	11
12	5/31/2014	3
13	6/30/2014	1
14	7/30/2014	7
15	8/29/2014	5
16	9/28/2014	6
17	10/28/2014	7
18	11/27/2014	8
19	12/27/2014	11
20	1/26/2015	7
21	11/25/2015	10
22
23		2015	2014	2013
24	MTD	0	0	4
25	YTD	7	69	10
Sheet8

Cell Formulas
Range	Formula
B24	=SUMPRODUCT(--(YEAR($A$3:$A$21)=B$23),--(MONTH($A$3:$A$21)=MONTH(TODAY())),--(DAY($A$3:$A$21)<=DAY(TODAY())),$B$3:$B$21)
B25	=SUMPRODUCT(--(YEAR($A$3:$A$21)=B$23),--($A$3:$A$21<=DATE(B$23,MONTH(TODAY()),DAY(TODAY()))),$B$3:$B$21)

 

[sachavez]

Stellar! Produced the desired result. Much appreciate for the quick assist and smart formulas.

Steve

Try this:

Excel 2010
	A	B	C	D
1
2	Date	Number
3	9/3/2013	3
4	10/3/2013	3
5	11/2/2013	4
6	11/22/2013	2
7	1/1/2014	11
8	1/31/2014	5
9	3/2/2014	5
10	4/1/2014	8
11	5/1/2014	11
12	5/31/2014	3
13	6/30/2014	1
14	7/30/2014	7
15	8/29/2014	5
16	9/28/2014	6
17	10/28/2014	7
18	11/27/2014	8
19	12/27/2014	11
20	1/26/2015	7
21	11/25/2015	10
22
23		2015	2014	2013
24	MTD	0	0	4
25	YTD	7	69	10
Sheet8

Cell Formulas
Range	Formula
B24	=SUMPRODUCT(--(YEAR($A$3:$A$21)=B$23),--(MONTH($A$3:$A$21)=MONTH(TODAY())),--(DAY($A$3:$A$21)<=DAY(TODAY())),$B$3:$B$21)
B25	=SUMPRODUCT(--(YEAR($A$3:$A$21)=B$23),--($A$3:$A$21<=DATE(B$23,MONTH(TODAY()),DAY(TODAY()))),$B$3:$B$21)