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

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

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

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

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

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

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?