Counting Filtered Records

  • Thread starter Thread starter Chuck Moore
  • Start date Start date
C

Chuck Moore

I need to be able to filter employee records and then
count the records as a result of the filter. For example,
I have 600 employees and filter them by department. I
then want to count the filtered records. e.g. 45
employees in the shipping department. When i enter a
formula it still counts the entire 600 and not just the 45
on the screen after the filter.

Any suggestions?
 
Hey JMay,

Worked like a charm. After two hours of searching through
the Help menu and trying various routes without success,
your suggestion worked in 2 minutes. Just need to keep
the formula out of the column that you are counting or you
get an error message.

Thanks a bundle.

Chuck
 
Back
Top