Something like this:

=SUMIFS($C$8:$C$30,$A$8:$A$30,">"&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),$A$8:$A$30,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())+13,1))

But your months should be actual dates like 1-01-2018 and formated as dd-mmmm-yyyy