Thread
:
Countif Statement
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
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
Reply With Quote