Date range (SUMIFS)

Hi,

I'm basically having issues with the following equation:

=SUMIFS(sheet1!M:M,sheet1!D:D,main!C12,sheet1!G:G,main!E7)

So the part of the equation I need help with is in bold. sheet 1 contains a table with a range of days with in the month and i need to pick up everything within that month. However, as it'll only pick up one day of the month, depending on what i put in "main!E7". How do i make it so it picks up everything within that month?

for example:
Sheet 1:
27/11/2013 5
22/11/2013 6
20/11/2013 7

Main
1/11/2013 =equation


I need the main the pick up the 3 numbers in sheet 1.

Thanks

thank you

Another quick question!
I'd like the cell to pick up the number if its a day with a specific month, going at the back of my initial question.
So for example, date being 1/01/2014:

Column A
25/01/14 - 12
23/01/14 - 55
19/02/14 - 87


Column B
12
55
0

thanks

Nevermind! I figured it out!