enter this formula at the end of column i
=subtotal(2,i2:i735)
use appropriate range, i supposed that your data starts from row 2 and
goes to row 735.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=523025