Sum for the month for current year.

[merchguy]

OK, here is my problem. I have the following formula that gives me the sum a cell in Column K if the cell in Column A has a date of 1/xx/2009:

=SUMPRODUCT(('Tourney Stats'!$A$14:$A$9996<>"")*(MONTH('Tourney Stats'!$A$14:$A$9996)=1)*(YEAR('Tourney Stats'!$A$14:$A$9996)=2009)*('Tourney Stats'!$K$14:$K$9996))​

I would like to adjust this formula to where after 2009, it will start calculating only 2010, so basically go blank at the end of 2009 and start all over in 2010. I have a series of these that basically sum up for each month of the year.

Macros are not an option since I am using Office 2008 for Mac. I know that all I basically need to do is change =2009 to another command but I can't figure it out.

Thanks for your help,

Merch

 

[jasonb75]

Try
=SUMPRODUCT(('Tourney Stats'!$A$14:$A$9996<>"")*(MONTH('Tourney Stats'!$A$14:$A$9996)=1)*(YEAR('Tourney Stats'!$A$14:$A$9996)=YEAR(TODAY()))*('Tourney Stats'!$K$14:$K$9996))

Hope this helps
​

 

[merchguy]

Try
=SUMPRODUCT(('Tourney Stats'!$A$14:$A$9996<>"")*(MONTH('Tourney Stats'!$A$14:$A$9996)=1)*(YEAR('Tourney Stats'!$A$14:$A$9996)=YEAR(TODAY()))*('Tourney Stats'!$K$14:$K$9996))

Hope this helps
​

Doh, I was using the TODAY(), but didn't have the =YEAR in front of it. Thanks for the help.