Closest solution I have so far is to make a separate column for month
=month(a2)

Then use =SUM(IF(B2:B48=10,H2:H48),0)
10 being october