Hello:

I have this below compare in a CELL...

=SUMPRODUCT((Clarity!$A$1:$A$3000=A27)*(Clarity!$B $1:$B$3000="January 2012"),Clarity!$E$1:$E$3000)

Everything works but I need to insert something other than a literal "2012" when the year flips to 2013 or I will have to update 12 CELLS for 17 people every year... is there a way to insert a MACRO for each of the twelve monthly CELLS, such as;

="January "& NOW(YEAR) or something different that works????

Thanks in advance