try this in Sheet2

=SUMPRODUCT(--(Sheet1!B2:B9=DATE(2010,2,1)),--(Sheet1!B2:B9<=DATE(2010,3,1)),--(Sheet1!A2:A9="Fred"))

Adjust the range to suit yours
--
Hope this help

Please click the Yes button below if this post have helped answer your needs

Thank You

cheers, francis





"Sunflower" wrote:

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