Trying to track Sales to a month,year

Hi, welcome to the forum

1. You can probably do away with the Month column, we can build that into the formula.
2. You would probably be better served using SUMIFS, rather than SP (more efficient)
3. You may even be able to use a Pivot Table
4. To assist you better, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Assuming you searching month is in L2 and year is in M2 cells

then try

=SUMPRODUCT((MONTH(E2:E30)=L2)*(YEAR(E2:E30)=M2)*(J2:J30))

Check the attached file.

Try this.

1st, put your dates downwards in a column (Use real dates 1/1/2015, 1/2/2015 etc)...

	M	N
2	1/1/2015	0
3	2/1/2015	0
4	3/1/2015	0
5	4/1/2015	0
6	5/1/2015	0
7	6/1/2015	0
8	7/1/2015	0
9	8/1/2015	0
10	9/1/2015	0
11	10/1/2015	351.53

N2=SUMIFS($J:$J,$E:$E,">="&M2,$E:$E,"<"&EDATE(M2,1))
copied down

You can do the exact same thing for the year...

	P	Q
2	1/1/2015	3834.31
3	1/1/2016	11916.75

Q2=SUMIFS($J:$J,$E:$E,">="&P2,$E:$E,"<"&EDATE(P2,12))
copied down