What function do I use to summarize data levels on three sheets?

[Learningfast]

I am looking at a workbook with three sheets
One has detail level (all products sold)
The next is summarized by department
The next is summarized by shops
There are "+" signs on the side of the workbooks that look like a function
but I do not know how to do this.
can you help me to use this function?
Thanks

 

[Dave Peterson]

You can get those outlining symbols a couple of ways.

One is to sort your data by a key column, then use Data|Subtotals.

Another way is to select some rows and use Data|Group. (This takes a lot more
manual effort.)

 

[Learningfast]

Thank you.
It worked (quite simple).
I can now leave work.
Enjoy 2008.