We have a variety of payments that we receive during a given month. I'd like to be able to collect all payments that are entered in multiple columns within a specific date range. To clarify / simplify, here's a simple table that represents my sheet:

COLUMN A COLUMN C COLUMN E

ROW 1 DATE AMT1 AMT2
ROW 2 9/22/2013 25.00
ROW 3 9/30/2013 1000.00
ROW 4 10/12/2013 50.00
ROW 5 10/19/2013 1250.00
ROW 6 10/28/2013 75.00
ROW 7 11/1/2013 1500.00
ROW 8 11/2/2013 100.00

So, what I want is to be able to add the values in AMT1 and/or AMT2 that fall between 9/1/13 - 9/30/13 and save that value in CELL A10.

Then the same thing, but between dates 10/1/13 - 10/31/13 and save in CELL A11.

... and again for 11/1/13 - 11/30/13 and save in CELL A12.


I hope this is clear. Thank you for helping!!