see he

http://www.cpearson.com/excel/excelF.htm#CountBetween

will be an array formula, so for example,

=SUM((A1:A100)*(A1:A10<10))

you need to hold in shift, ctrl and hit enter once the formula is input


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=513150