But Data|Subtotal and Data|Filter don't play nice with each other.

=subtotal() will ignore the rows hidden by the autofilter.



Pete_UK wrote:

Please don't SHOUT.

You can apply a filter to the column which contains the words Subtotal
and Grand Total, and on the filter pull-down select Custom | Contains
| Total to see just the total rows, or Custom | Contains | Grand to
see just the Grand total row - same effect as the 1, 2, 3 choices.

Hope this helps.

Pete

On Oct 29, 11:44 am, Seebu wrote:
I AM GETTING SUBTOTALS WITHOUT THE SHOW AND HIDE DEAILS WHEN I MAKE SUBTOTAL
IN AN EXCEL WORKSHEET EXPORTED FROM AN ERP. I AM GETTING THE SUBTOTALS
WITHOUT THE 123 (+) SHOW AND (-)HIDE SIGNS ON LEFT HAND SIDE.
CAN ANY ONE PLEASE HELP TO FIND A SOLUTION TO HAVE SHOW AND HIDE DETAILS
BUTTON ALONG WITH THE SUBTOTAL.

THANKS
SEEBU

--

Dave Peterson