SUMIF inbetween date ranges

I have tried the tips from multiple blogs and forums and even followed along on video's just in case. For some reason I can't get my SUMIF to work properly.

I am creating a reconciliation report for expenses and also want to break this down by month for an easy summery.

Please help. I have been pulling my hair out. I know this is possible I am just not "getting it"! What I have attached is a super bare bones beginning. I didn't want to load all my work in and then have to change something major if my functions wouldn't work. Any help out there?

Screen shot 2014-10-14 at 4.27.44 PM.png

Hi,

An example using sumproduct to sum up october costs could be:

=sumproduct(--(month(a4:a10)=10),b4:b10)

Cheers