 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005Countif on multiple dates
I would like to know how I can write a countif to count the number of times dates are entered into a column and add those dates together. For example I would like to count the number of times that 12/9/05, 12/10/05, and 12/11/05 appear in a column that shows multiple dates. Thanks for the help. 12/9/05 12/10/05 12/13/05 12/22/05 12/10/05 12/30/05 12/9/05 12/10/05 12/13/05 12/22/05 12/10/05 12/30/05 12/9/05 12/10/05 12/13/05 12/22/05 12/10/05 12/30/05 One way: =SUM(COUNTIF(A:A,{"12/09/05","12/10/05","12/11/05"})) > I would like to know how I can write a countif to count the number of times > dates are entered into a column and add those dates together. For example I [quoted text clipped - 19 lines] > 12/10/05 > 12/30/05 Perfect solution!!! Is there a formula that will select a range? Say 12/01/05 - 12/06/05? Thanks > One way: > [quoted text clipped - 23 lines] > > 12/10/05 > > 12/30/05 Use Roger's solution. > Perfect solution!!! Is there a formula that will select a range? Say > 12/01/05 - 12/06/05? This may work for you: Assuming your dates are in Cells A1:A20 with the heading "Dates" in A1. B1: Dates B2: 12/9/05 B3: 12/10/05 B4: 12/11/05 C1: =DCOUNT(A1:A20,"Date",B1:B4) Does that help? *********** Regards, Ron > I would like to know how I can write a countif to count the number of times > dates are entered into a column and add those dates together. For example I [quoted text clipped - 19 lines] > 12/10/05 > 12/30/05 C1: =DCOUNT(A1:A20,"Date",B1:B4) Should be.... C1: =DCOUNT(A1:A20,"Dates",B1:B4) ("Date" changed to "Dates") *********** Regards, Ron > This may work for you: > [quoted text clipped - 36 lines] > > 12/10/05 > > 12/30/05 Hi Jim One way =SUMPRODUCT(--($A$1:$A$100>=DATE(2005,12,9),--($A$1:$A$1000<=DATE(2005,12,11)) If you wanted to make it easy to vary the dates being counted, then put your earliest date in C1, your latest date in D1 and change formula to =SUMPRODUCT(--($A$1:$A$100>=C1),--($A$1:$A$1000<=D1) Change range to suit. Regards Roger Govier > I would like to know how I can write a countif to count the number of times > dates are entered into a column and add those dates together. For example I [quoted text clipped - 19 lines] > 12/10/05 > 12/30/05 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.