EasyFilter have a option to do this.
You can use the subtotal function if you want if you filter on the same sheet
http://www.rondebruin.nl/easyfilter.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Suzanne" wrote in message ...
Hello. I'm setting up a results summary table that calculates from a detail
tab.
In the detail tab i'm capturing date of activity (where the user inputs a
date) 3/31/08. On the summary tab i want to calculate results by month year.
I inserted a column next to the activity date column in the detail tab;
tried and failed at formatting the m/dd/yy format to month year (Mar-2008) to
allow me to count and group by month year. Suggestions?
--
Thank you -- Suzanne.