| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif on multiple dates
One way:
=SUM(COUNTIF(A:A,{"12/09/05","12/10/05","12/11/05"})) In article , Jim wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif on multiple dates
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 "Jim" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif on multiple dates
Perfect solution!!! Is there a formula that will select a range? Say
12/01/05 - 12/06/05? Thanks "JE McGimpsey" wrote: One way: =SUM(COUNTIF(A:A,{"12/09/05","12/10/05","12/11/05"})) In article , Jim wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif on multiple dates
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 Jim wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fixing a typo
C1: =DCOUNT(A1:A20,"Date",B1:B4)
Should be.... C1: =DCOUNT(A1:A20,"Dates",B1:B4) ("Date" changed to "Dates") *********** Regards, Ron "Ron Coderre" wrote: 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 "Jim" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif on multiple dates
Use Roger's solution.
In article , Jim wrote: Perfect solution!!! Is there a formula that will select a range? Say 12/01/05 - 12/06/05? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF Multiple Conditions | Excel Discussion (Misc queries) | |||
| synchronizing the years for multiple dates | Excel Discussion (Misc queries) | |||
| COUNTIF using Dates | Excel Worksheet Functions | |||
| looking for a calendar template that I can import multiple dates | Excel Discussion (Misc queries) | |||
| COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions | |||
Linear Mode
