Countif Statement

[Guest]

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))

 

[Guest]

Thank you for a speedy response that does the trick

Souchie40

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

--
Don Guillett
SalesAid Software
(e-mail address removed)

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
(e-mail address removed)

Thank you for a speedy response that does the trick

Souchie40

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

--
Don Guillett
SalesAid Software
(e-mail address removed)

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