oops

=SUM(IF(dispatch quantity<0;IF((annual volume / dispatch quantity)turn
over speed;1)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Phillips" wrote in message
...
Try

=SUM(IF(dispatch quantity<0,IF((annual volume / dispatch quantity)turn
over speed,1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"a94andwi" wrote
in
message ...

Hello.

I have a worksheet containing appr. 9000 part numbers that have four
different columns as: annual volume, dispatch quantity and turn over
speed.

I want to count all rows where these conditions are true:

(annual volume / dispatch quantity)turn over speed

I thought I could do something like this but it turns out wrong:

=COUNTIF((annual volume/dispatch quantity); turn over speed)

This does not work.
Is there a way that I can do this easily?

note: the " ;" is correct. In my excel I use ; instead of " , ".

Thanks in advance

/Anders


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