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?