MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Autofilter


Posted by Ann Druery on July 15, 2001 6:17 PM

Doing a survey I have numbers from 0 to 5 to enter into different columns. Previously the Autofilter when I selected a number I'd entered in the selected column, it would give me the total number (not sum) of that selected i.e. there are 56 of 2. This would show on the lower left hand side of my screen. This facility has disappeared. It is only showing the sum of the figure selected. Can anyone assist me to regain this facility? I thank you in anticipation.


Posted by Ivan F Moala on July 16, 2001 3:38 AM

Try running this macro to reset the
statusbar;

Sub E()
Application.StatusBar = False
End Sub


HTH

Ivan

Posted by Richie Turner on July 16, 2001 4:35 AM

I still get the message (1 of 57 records found) but only sometimes, not sure what makes it disappear. I thought it may have something to do with updating references on the same page. If the sheet is set to automatically update references, each time the filter is changed, this causes the references to update and in turn causes the status bar message to update too, thus losing the the "1 of 57 records found" message.

Not sure if this is the cause and if it is I'd like to know how to get around it. I'd be very interesed to hear.

cheers

Richie

Posted by Mark W. on July 16, 2001 7:34 AM

> It is only showing the sum of the figure selected

This sounds supiciously like AutoSum; however, its
results are displayed on the right-hand side of the
Status bar -- not the left. If you right-click
the Status bar you can select any of the available
summary functions including Sum, Count and Count Nums.