Hello all!

I have been reading the discussion groups and any website I can find on
countif functions with multiple criteria and I cannot seem to find the
answer. I have a spreadsheet that looks something like this:

A B
Dale 1/5/05
Susan 2/5/05
Dale 2/5/05
Dale 2/5/05
Mike 1/5/05

I want to have a formula that will count how many times the name "Dale" in
column A shows up with the date "2/5/05" in column B. I have a summary sheet
and the information is on sheet '2005'! With the example above, my answer
would be 2.

I have tried several formulas including:

=COUNT('2005'!G:G="*Dale*",'2005'!A:A="1/5/05")
=SUMPRODUCT(('2005'!G:G="*Dale*")*('2005'!A:A="2/5/05"))

What am I doing wrong? Thanks for all your help in advance.