1) =SUBTOTAL(3,B2:B20) gives the number of items in a filtered list.

2) I will leave that to Ron.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"WYN" wrote in message
...
hi all, i have two questions (1) ineed help on a formula to count names
in a
filtered list. (2) is it there a way to use ron's easyfilter when the page
is
protected. any help will be appreciated.
thx wynb
--
wynb