Im trying to count the number of entries for every month from a list of cells.
I've got the basic count if function but how do i tell it to count every
entry for jan 07?
Should i no be using countif?

Thanks

=SUMPRODUCT(--(YEAR(A2:A20)=2007),--(MONTH(A2:A20)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naz" wrote in message
...
Im trying to count the number of entries for every month from a list of
cells.
I've got the basic count if function but how do i tell it to count every
entry for jan 07?
Should i no be using countif?

Thanks

=countif(a:a,"="&date(2007,1,1)) - countif(a:a,""&date(2007,1,31))

Count the days larger than or equal to than Jan 1, 2007 and then subtract the
number of days larger than Jan 31, 2007.



naz wrote:

Im trying to count the number of entries for every month from a list of cells.
I've got the basic count if function but how do i tell it to count every
entry for jan 07?
Should i no be using countif?

Thanks

--

Dave Peterson

Thanks bob but i cant get it to work im getting the #value! error and i dont
understand why...heres what im working with...

Date requested
01/01/07
02/01/07
01/02/07
02/02/07
31/12/06

raised in jan07 =
raised in feb 07 =

"Bob Phillips" wrote:

=SUMPRODUCT(--(YEAR(A2:A20)=2007),--(MONTH(A2:A20)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naz" wrote in message
...
Im trying to count the number of entries for every month from a list of
cells.
I've got the basic count if function but how do i tell it to count every
entry for jan 07?
Should i no be using countif?

Thanks

Works fine for me naz. Are the cells formatted as text? Is there an error in
one of the cells?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naz" wrote in message
...
Thanks bob but i cant get it to work im getting the #value! error and i
dont
understand why...heres what im working with...

Date requested
01/01/07
02/01/07
01/02/07
02/02/07
31/12/06

raised in jan07 =
raised in feb 07 =

"Bob Phillips" wrote:

=SUMPRODUCT(--(YEAR(A2:A20)=2007),--(MONTH(A2:A20)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"naz" wrote in message
...
Im trying to count the number of entries for every month from a list of
cells.
I've got the basic count if function but how do i tell it to count
every
entry for jan 07?
Should i no be using countif?

Thanks

yup it was the format..many thanks

"Bob Phillips" wrote:

Works fine for me naz. Are the cells formatted as text? Is there an error in
one of the cells?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naz" wrote in message
...
Thanks bob but i cant get it to work im getting the #value! error and i
dont
understand why...heres what im working with...

Date requested
01/01/07
02/01/07
01/02/07
02/02/07
31/12/06

raised in jan07 =
raised in feb 07 =

"Bob Phillips" wrote:

=SUMPRODUCT(--(YEAR(A2:A20)=2007),--(MONTH(A2:A20)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"naz" wrote in message
...
Im trying to count the number of entries for every month from a list of
cells.
I've got the basic count if function but how do i tell it to count
every
entry for jan 07?
Should i no be using countif?

Thanks

thats great, thanks dave

"Dave Peterson" wrote:

=countif(a:a,"="&date(2007,1,1)) - countif(a:a,""&date(2007,1,31))

Count the days larger than or equal to than Jan 1, 2007 and then subtract the
number of days larger than Jan 31, 2007.



naz wrote:

Im trying to count the number of entries for every month from a list of cells.
I've got the basic count if function but how do i tell it to count every
entry for jan 07?
Should i no be using countif?

Thanks

--

Dave Peterson