I have a spreadsheet with 10 columns and 735 rows. I need to be able to
filter down on these rows (columns b and i - know how to do this) and at the
bottom of column (i) I need it to count the number of cells in column (i)
that are left after the various filters have been applied.

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

thanks heaps it works just fine. would never have thought of sub total.

"starguy" wrote:


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