Excel auto filter

I HAVE A SPREADSHEET WHICH WHEN I ENGAGE A FILTER, THE AMOUNT OF VALUES SELECTED BY THE FILTER SHOWS ON THE STATUS BAR AS A COUNT OF THE TOTAL IE 3 OF 136 RECORDS FOUND. THIS COUNT APEARS TO BE AUTOMATIC ON THIS PARTICULAR SHEET BUT I CANNOT ACTIVATE IT ON ANY OTHER SHEET I HAVE. i HAVE TRIED RIGHT CLICKING ON THE STATUS BAR AND SELECTED EACH OF THE OPTIONS IN TURN BUT NONE APPEAR TO ACTIVATE THIS FUNCTION.