Using IF function for dates

[cmd225]

Hello, I'm working on a cash flow/budgeting spreadsheet.

I have a column for "invoice due date". In separate columns, I want to display the total dollar amount of another cell, only IF the due date falls in certain dates.

So basically, if the Date in A1 is greater than 5/1/2017 and less than 5/31/2017, then cell C1 should show the total dollar amount from cell B1, otherwise it should show 0 in C1.

I've tried variations of IF and AND formulas and I'm not getting anywhere.

[JohnTopley]

Look at SUMIFS

=SUMIFS(B:B,C:C,">=" & G1,C:C,"<=" & G2)

where G1 and G2 are start/end period dates