| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
