You can use the SUBTOTAL function like

=SUBTOTAL(3,Full_Range)&" items out of "&COUNTA(Full_Range)&" found"

for an explanation see

http://www.contextures.com/xlautofilter02.html#Count



--


Regards,


Peo Sjoblom


"roxanne" wrote in message
...
I have all of my data filtered.Ex. : I go in and select filter for people
by
the name of Smith. At the bottom left corner it should say "4 items out of
52
found". My spreadsheet no longer gives me that information it just says
"filter mode". I never had this problem before, I'm assuming I have
accidently keyed something in wrong.
HELP