Countif Statement

[souchie40]

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

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"souchie40" <[email protected]> wrote in message
news:[email protected]...
> 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

[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
> [email protected]
> "souchie40" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"souchie40" <[email protected]> wrote in message
news:[email protected]...
> 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
>> [email protected]
>> "souchie40" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>