Thanks Bob

The problem was that each cell criteria differed from the one above.
some cells were to be counted if they were less than the value in the
next column, others to be counted if they were more and others if they
were equal. I think I have it worked out. I can get the result if I
use

=SUM(K4$D4)+SUM(K5<$D5)+SUM(K6<$D6)+SUM(K7=$D7) etc

which seems to work.

Thanks for the reply, much appreciated

Oz


--
ozcank


------------------------------------------------------------------------
ozcank's Profile: http://www.excelforum.com/member.php...fo&userid=5328
View this thread: http://www.excelforum.com/showthread...hreadid=484779