View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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