MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTING NAMES IN DATA BASE


Posted by JACK on September 14, 2001 1:09 PM

I HAVE A DATA BASE IN EXCEL AND I'M USING
DATA, FILTER, AUTO FILTER TO SORT THE DATA BASE.
WHEN I SELECT A FIELD TO SORT AND THE DATE COMES UP IN THE ACTIVE SHEET. I NEED TO KNOW HOW MANY NAMES THAT ARE SELECTED. HOW CAN I COUNT THE NUMBER OF NAMES IN THE ACTIVE DATA BASE?


Posted by IML on September 14, 2001 1:37 PM

Not sure I exactly follow, but try
=SUBTOTAL(3,A:A)-1
for your count of visable items in column A

Good luck