sumif? sumproduct? not sure which...

With Excel 2003 SUMPRODUCT is your friend for this. See attached.

If using Excel 2007 or later, you could use COUNTIFS.

Rather than hardcode dates into the formula I've added a start and end date cell. This makes it easier when things need updating further down the line.