Martin

Try
'monthly trade tracking 2008'!G4:
=SUMPRODUCT(--('Trade Tracking Spreadsheet 2008'!C4:C2000="DT"),('Trade Tracking Spreadsheet 2008'!L4:L2000),--(MONTH('Trade Tracking Spreadsheet 2008'!M4:M2000)=6))

rylo