It will if you put them around each group.

--
Regards,
Tom Ogilvy

Andy Z wrote in message
...
Any ideas for a variation on this -

I have sheets set like this-


<MonthType1<MonthType2<MonthType3<PreviousMonth Type1<PreviousMonthType2
<PreviousMonthType3
etc....

I want to maintain the order of the grouping, but summarize each type
(SummaryType1, SummaryType2, SummaryType3) with formulae that will
automatically update when I add new sheets each month. Is it
possible?

Seems like the First:Last trick won't quite work given the grouping
order of the sheets...

Thanks for any help!


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