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

Countif Statement
 

try sumproduct
=sumproduct((j21:j27a2)*(j21:j27<j2))

--
Don Guillett
SalesAid Software

"souchie40" wrote in message
...
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

Countif Statement
 

Thank you for a speedy response that does the trick

Souchie40

"Don Guillett" wrote:

try sumproduct
=sumproduct((j21:j27a2)*(j21:j27<j2))

--
Don Guillett
SalesAid Software

"souchie40" wrote in message
...
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

Countif Statement
 

glad to help

--
Don Guillett
SalesAid Software

"souchie40" wrote in message
...
Thank you for a speedy response that does the trick

Souchie40

"Don Guillett" wrote:

try sumproduct
=sumproduct((j21:j27a2)*(j21:j27<j2))

--
Don Guillett
SalesAid Software

"souchie40" wrote in message
...
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