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