count the number of cell entries after filtering

[Gazza]

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.

 

[starguy]

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 an
goes to row 735

 

[Gazza]

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