How can I always get subtotals (4 of 12 records)when I filter a sh

[Frank P.]

With some spreadsheets, I get an indication of how many records are returned
when using AutoFilter. But somketimes I get no such indication.

How can I turn on the # of records retruned by an autofilter operation in
Excel 2003?

Thanks,
Frank

 

[Debra Dalgleish]

There's information on the record count, and a couple of workarounds, here:

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