Change COUNT to SUM as I gave you.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"a94andwi" wrote in
message ...

Here is the final formula:

=COUNT(IF(dispatch quantity<0; IF((annual quantity/dispatch
quantity)<Turn over speed;1)))

Thanks again.


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile:
http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=535898