Countif Statement

Hi everyone,

After a bit of help with this statement

=COUNTIF(J21:J27,(">A2,<J2"))

All the cell references are the same custom date format ([$-809]d mmmm yyyy;@)
What I want to do is count the number of dates that fall between the A2 and
J2 references at the moment I get a '0' return.

Any suggestions greatly recieved

MTIA

Souchie40

try sumproduct
=sumproduct((j21:j27>a2)*(j21:j27<j2))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"souchie40" <souchie40@discussions.microsoft.com> wrote in message
news:F5C58053-508B-4697-A45F-8FFFD66429F2@microsoft.com...
> Hi everyone,
>
> After a bit of help with this statement
>
> =COUNTIF(J21:J27,(">A2,<J2"))
>
> All the cell references are the same custom date format ([$-809]d mmmm
> yyyy;@)
> What I want to do is count the number of dates that fall between the A2
> and
> J2 references at the moment I get a '0' return.
>
> Any suggestions greatly recieved
>
> MTIA
>
> Souchie40

Thank you for a speedy response that does the trick

Souchie40

"Don Guillett" wrote:

> try sumproduct
> =sumproduct((j21:j27>a2)*(j21:j27<j2))
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "souchie40" <souchie40@discussions.microsoft.com> wrote in message
> news:F5C58053-508B-4697-A45F-8FFFD66429F2@microsoft.com...
> > Hi everyone,
> >
> > After a bit of help with this statement
> >
> > =COUNTIF(J21:J27,(">A2,<J2"))
> >
> > All the cell references are the same custom date format ([$-809]d mmmm
> > yyyy;@)
> > What I want to do is count the number of dates that fall between the A2
> > and
> > J2 references at the moment I get a '0' return.
> >
> > Any suggestions greatly recieved
> >
> > MTIA
> >
> > Souchie40
>
>
>

glad to help

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"souchie40" <souchie40@discussions.microsoft.com> wrote in message
news:FB76F7E9-759E-411D-82EE-3225EFB01541@microsoft.com...
> Thank you for a speedy response that does the trick
>
> Souchie40
>
> "Don Guillett" wrote:
>
>> try sumproduct
>> =sumproduct((j21:j27>a2)*(j21:j27<j2))
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "souchie40" <souchie40@discussions.microsoft.com> wrote in message
>> news:F5C58053-508B-4697-A45F-8FFFD66429F2@microsoft.com...
>> > Hi everyone,
>> >
>> > After a bit of help with this statement
>> >
>> > =COUNTIF(J21:J27,(">A2,<J2"))
>> >
>> > All the cell references are the same custom date format ([$-809]d mmmm
>> > yyyy;@)
>> > What I want to do is count the number of dates that fall between the A2
>> > and
>> > J2 references at the moment I get a '0' return.
>> >
>> > Any suggestions greatly recieved
>> >
>> > MTIA
>> >
>> > Souchie40
>>
>>
>>