problems with sumproducts

Hi there, please help me with this i'm pulling my hair out.. i've attached an example of what i'm trying to do...

Basically i'm trying to create a data drop type file that can be reused.. i wasnt to be able to add the date onto tab 2 and obtain valued on tab one.. the data formatt will always be consistant so thats not a problem.. the issue arrises becuase i cant get the formula to work..

when i filta the masta date with the same criteria it brings up a different value to what the formula is finding (they are actually way out) i have no idea what i'm doing wrong....

What i need to know is in values c4 the total value (datadrop col D) of everything that has a date (data drop Col H) less than 12/03/2010

In c5 need to know is in values c4 the total value (datadrop col D) of everything that has a date (data drop Col H) that is equal to or greater than 12/03/2010 but less than 18/06/2010

and

In c6 need to know is in values c4 the total value (datadrop col D) of everything that has a date (data drop Col H) that is equal to or greater than 18/06/2010 but less than 16/07/2010

Many thanks