Formaula To CFalculate Total Within Dates

Hi all,

I have attached an example workbook to assist, which has 'Date' in column A, 'Type' in column B and 'Total' in column C. I am looking for a formula that will allow me to calculate the total between two dates, but excluding something in the 'Type' column (B).

Example: Total 1/07/2013 to 31/07/2013, consecutively, excluding Type1 = 8187.

I know this from using the filter, but is there a formula that can do it automatically? I've tried sumifs, sumproduct to no avail.

Cheers, A