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
|