Hi Frank,

Thank you for the suggestion of using a Pivot Table.

I tried it out but the results included the Filtered Hidden Rows as
well as the Filtered Visible Rows. I require only the data of the
Filtered Visible Rows. Does this mean that I first have to copy the
Filtered Visible Rows to another location? The Filtered data will be
constantly changing and a solution that can be performed on-the-fly
would be more suitable.

Is there any way of providing a solution using Formula or VBA to count
the individual departments and then count the subset of departments
within the Filtered Visible Rows to ultimately provide a summary count
for each department?

Frank Kabel wrote:
*Hi
I would use a pivot table for this. Using the department as row item
and the count of department as data item. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
--
Regards
Frank Kabel
Frankfurt, Germany
*[/color]

Kind regards,
QTE


---
Message posted from http://www.ExcelForum.com/