put year in a1
then
=SUMPRODUCT(($N$7:$N$35>=DATE($A$1,1,1))*($N$7:$N$35<=DATE($A$1,1,31)))
will give total for jan of year in a1
it gets a tad more complicate if you want to auto increment on drag, and then more fun if you want to span 2008-2009!