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

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