count number of dates in range
 

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

count number of dates in range
 

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

count number of dates in range
 

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