If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|