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

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

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

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 wrote:

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

What function do I use to summarize data levels on three sheet
 

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

"Dave Peterson" wrote:

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 wrote:

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