Trying to do something really simple here but cant seem to get it right


have a list of dates

12/01/2009
13/01/2009
12/01/2009
13/02/2009
14/01/2009


obviously the list is longer!

all i want to be able to do is count the number of entries for eg. jan

have tried =countif(A1:A5,"=**/01/2009")

but this just returns an error message

can anyone help prob dead simple if you know how!
thanks
wend




--
wendy

all i want to be able to do is count the
number of entries for eg. jan

For January of *any* year or will your dates all be within the same year?

For January of *any* year:

=SUMPRODUCT(--(MONTH(A1:A100)=1)

Note that if there are any empty cells in the range they will be evaluated
as month 1 (January). To account for that:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(A1:A100<""))

To count for a specific year:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2009))


--
Biff
Microsoft Excel MVP


"wendy" wrote in message
...

Trying to do something really simple here but cant seem to get it right


have a list of dates

12/01/2009
13/01/2009
12/01/2009
13/02/2009
14/01/2009


obviously the list is longer!

all i want to be able to do is count the number of entries for eg. jan

have tried =countif(A1:A5,"=**/01/2009")

but this just returns an error message

can anyone help prob dead simple if you know how!
thanks
wend




--
wendy

T. Valko;3241754 Wrote:
all i want to be able to do is count the-
number of entries for eg. jan-

For January of *any* year or will your dates all be within the same
year?

For January of *any* year:

=SUMPRODUCT(--(MONTH(A1:A100)=1)

Note that if there are any empty cells in the range they will be
evaluated
as month 1 (January). To account for that:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(A1:A100""))

To count for a specific year:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2009))


--
Biff
Microsoft Excel MVP


"wendy" wrote in message
...-

Trying to do something really simple here but cant seem to get it
right


have a list of dates

12/01/2009
13/01/2009
12/01/2009
13/02/2009
14/01/2009


obviously the list is longer!

all i want to be able to do is count the number of entries for eg.
jan

have tried =countif(A1:A5,"=**/01/2009")

but this just returns an error message

can anyone help prob dead simple if you know how!
thanks
wend




--
wendy -
perfect thank you so much x




--
wendy

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"wendy" wrote in message
...

T. Valko;3241754 Wrote:
all i want to be able to do is count the-
number of entries for eg. jan-

For January of *any* year or will your dates all be within the same
year?

For January of *any* year:

=SUMPRODUCT(--(MONTH(A1:A100)=1)

Note that if there are any empty cells in the range they will be
evaluated
as month 1 (January). To account for that:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(A1:A100""))

To count for a specific year:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2009))


--
Biff
Microsoft Excel MVP


"wendy" wrote in message
...-

Trying to do something really simple here but cant seem to get it
right


have a list of dates

12/01/2009
13/01/2009
12/01/2009
13/02/2009
14/01/2009


obviously the list is longer!

all i want to be able to do is count the number of entries for eg.
jan

have tried =countif(A1:A5,"=**/01/2009")

but this just returns an error message

can anyone help prob dead simple if you know how!
thanks
wend




--
wendy -
perfect thank you so much x




--
wendy