Wth is an excel summary? and structure diagram?

Omg i am quite the excel n00b but i need to know :P i just cant find
what an excel spreadsheet summary is..anyone have any idea?


---
Message posted from http://www.ExcelForum.com/

nippalony wrote:

Omg i am quite the excel n00b but i need to know :P i just cant find
what an excel spreadsheet summary is..anyone have any idea?


---
Message posted from http://www.ExcelForum.com/

Maybe if you try and explain what you would like to be able to do,
someone would help. Are you trying to sum a column or row? Do you
want to add values from several sheeet onto a seperate sheet?
just state exactly what you would like to accomplish and the people
here can be quite helpful.

gls858

With just the info you have provided I would guess that someone is expecting you
to take a bunch of raw data, much like a dump out of a mainframe, or database,
and then summarise that data in a nice friendly manner such as Excel's Pivot
tables will do for you, eg:-


A B
1 Code Val
2 b 3
3 a 1
4 c 2
5 c 2
6 b 3
7 a 1
8 b 1
9 a 4

One example of a summary of the above would be

D E
1 Code Sum of Val
2 a 6
3 b 7
4 c 4

This is all achieved automatically by using something like a Pivot table
though, and you don't do it all manually :-)

As to the structure diagram, hard to say without more info and an example of
your data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"nippalony " wrote in message
...
Omg i am quite the excel n00b but i need to know :P i just cant find
what an excel spreadsheet summary is..anyone have any idea?


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.682 / Virus Database: 444 - Release Date: 11/05/2004