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

  • Thread starter Thread starter Learningfast
  • Start date Start date
L

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
 
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.)
 
Back
Top