12 month sum based on current date

Try 2 SUMPRODUCT, one for this and another for next year:

=SUMPRODUCT(ISODD(ROW($C$8:$C$30)-MIN(ROW($C$8:$C$30))+1)*(INT((ROW($C$8:$C$30)-MIN(ROW($C$8:$C$30)))+1/2)-2>MONTH(TODAY()))*$C$8:$C$30)+
SUMPRODUCT(ISODD(ROW($C$8:$C$30)-MIN(ROW($C$8:$C$30))+1)*(INT((ROW($C$8:$C$30)-MIN(ROW($C$8:$C$30)))+1/2)-2<=MONTH(TODAY()))*$I$8:$I$30)