Hi all - hope somebody can help with this dilema!

I have a worksheet and wondered if anybody could help with this problem:

Column A:A contains a date (within 2005).
Next to each date in column B:B contains a persons name either Bob, Dave or
Andy, again throughout the entire column.

These 2 columns represent who got a sale on a particular date, I want a
formula that will add up the number of sales for each person for each month.

For the next 12 columns (for each of the 12 months) I want each column to
tell me the total number of Bob's there are for January, how many Dave's
there are in January, and how many Andy's there are in January, and so on
for the rest of the columns for the remaining months.

Is there are formula that could calculate the number of times a persons name
appears within a certain month.

I would like to avoid using the 'Sort...' function from the 'Tools' Menu if
possible.


Does anybody have any ideas on how this can be done.

Many thanks for your help in advance.
Mark