count number of dates in range

  • Thread starter Thread starter Sunflower
  • Start date Start date
S

Sunflower

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
 
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))
 
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
 
Back
Top