counting filtered cells

  • Thread starter Thread starter john g mcmillan
  • Start date Start date
J

john g mcmillan

hi there, i am a new user and have just used exel 97 to make an
electronic version of my glider logbook.it is all working very well and
i can use auto filter to tell me my total and subtotal flying times in
various gliders ,places and when i was flying solo or dual.what i can't
work out is when i end up with a filtered list,i want to count how many
cells are in a colmn in that list so i can then tell how many flights
ihave done in that list.when i try counting them i end up with the
number of flights from the lowest number to the highest number as they
are filtered from a log that lists them consecutively instead of the
flights in the list, please can anyone help, allthe best Jock.
 
Have you looked at the left hand bottom corner of your screen
where you normally get the word "ready" ?
It shows on my system for instance "5 out of 20 records found"
Regards
Bill K
 
Back
Top