Hi
try following:
countif($firstrow$firstcolumn:$lastrow$lastcolumn; (annualvolume/dispatchquantity)turnoverspeed)
regards
Axel
"a94andwi" wrote:
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