Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count number of days from a range of dates & some repite. | Excel Discussion (Misc queries) | |||
Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions |