COUNTIF

A

Alex H

Hi

if I want to count the number of rown where B4:B65535 > 31/07/06 and <
01/08/07 and C4:C65535 = "No" how would I express this please

Thanks
A
 
D

David Biddulph

=SUMPRODUCT((B4:B65535>--("31/07/06"))*(B4:B65535<--("1/08/07"))*(C4:C65535
= "No"))
 
S

Sandy Mann

Hi David,

As Bob Philips often points out --("1/08/07") is ambiguous in that it can be
interpreted as August 1 2007 or January 8 2007 depending on your settings.
It is therefore better to use Date(2007,8,1) which, (as I am sure you
already know), works regardless of the regional setting you have

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
A

Alex H

Thanks you both so very much -

A

Sandy Mann said:
Hi David,

As Bob Philips often points out --("1/08/07") is ambiguous in that it can
be interpreted as August 1 2007 or January 8 2007 depending on your
settings. It is therefore better to use Date(2007,8,1) which, (as I am
sure you already know), works regardless of the regional setting you have

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Top