Need help counting events within a certain date ranges

My workbook is used to analyse various events occuring within 5 seperate teams. As such, the first five worksheets contain the raw data entries for each team. The next work sheets count and sum various events and critera for the five teams.

For example, say there were five sales teams selling cars. Each team's worksheet have the same columns; make of car, body type, colour, date sold. Each entry is entered on a new row.
The sales figures for each month are entered and so the workbook is ongoing.

Now, say I want to count the number of red cars sold each month. I can total the number of times "red" appears in a given column easily enough, but to add the "month criterion" in a corresponding column as well proves very difficult.

Please help? What would my function arguments look like?

It's very similar to this but sales are entered in as dates, eg. 01/07/12 (dd/mm/yy) and then summed in months: Total red cars sold in July.

Thanks, okay it looks like this.

Don't see 5 teams represented here. Most folks find help sooner if the data in their attachments more closely resembles/represents the actual data (privacy and business sensitivities considered, of course).