Try one of these...

Use cells to hold the criteria.

D2 = Fred
E2 = lower date boundary = 2/1/2010
F2 = upper date boundary = 2/28/2010

In Excel 2007:

=COUNTIFS(A2:A20,D2,B2:B20,"="&E2,B2:B20,"<="&F2)

In any version of Excel:

=SUMPRODUCT(--(A2:A20=D2),--(B2:B20=E2),--(B2:B20<=F2))

--
Biff
Microsoft Excel MVP


"Sunflower" wrote in message
...
In column A, various contractor names are listed. In column B, completion
dates have been entered for when their projects were completed thoughout
the
year. I would like to have the next spreadsheet tab summarize the data so
it
lists the number of times between 2/1/20010 and 2/28/2010 a project was
completed for "Fred."

Can you tell me what formula I should enter? Thanks