Countif Statement

S

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
 
S

souchie40

Thank you for a speedy response that does the trick

Souchie40

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

--
Don Guillett
SalesAid Software
[email protected]
souchie40 said:
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
Click to expand...
Click to expand...
 
D

Don Guillett

glad to help

--
Don Guillett
SalesAid Software
[email protected]
souchie40 said:
Thank you for a speedy response that does the trick

Souchie40

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

--
Don Guillett
SalesAid Software
[email protected]
souchie40 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top