Nested sub total

[mohebk]

Hi,
Is there away in excel 2003 that I can do nested subtotals. I am able to subtotal on one field by going to Data/Subtotals. But not able to do it on more than one field.

Thanks


Mo

 

[SkipVought]

You can do this repeatedly by, on subsequent itterations UNCHECK Replace current subtotals

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

Untick "Replace current subtotals" checkbox before doing the next level.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[GlennUK]

Darn it! Too slow again.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

It's my "famous"...

Russian hands and

Roman fingers!!! ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mohebk]

Faaaaaaaaantastic,
Thank you all

Mo

 

[Gavona]

Be warned. This approach can lead to incorrect results: thread707-1485125.

Gavin