HELP! Best way to make statistical table

[mvgard]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Help! I am so frustrated! I want to easily make a table that summarized my categorical data (where purchased) by cost. For cost I want to have a column for sum, count, and average. I am able to get a pivot table that summarizes this data using one statistical analysis (e.g., sum); however, how do I go about getting the extra columns that will give me the sum, average, etc. I want this table to automatically refresh as new data is entered.

Furthermore, I would like to be able to add to this table other variables such that by category I could see the cost by sum, count and average, then the profit by sum, count, average, etc.

I can obviously make a table using formulas; however, it would seem that this type of table should be easy for excel to create - the tables it wants to create are even more complicated than I am asking for!!!!

Thank you!!!!

 

[JE McGimpsey]

Help! I am so frustrated! I want to easily make a table that summarized my
categorical data (where purchased) by cost. For cost I want to have a column
for sum, count, and average. I am able to get a pivot table that summarizes
this data using one statistical analysis (e.g., sum); however, how do I go
about getting the extra columns that will give me the sum, average, etc. I
want this table to automatically refresh as new data is entered.

Seems to me you can add the cost field three times, using the Sum,
Average and Count functions...

 

[mvgard]

Help! I am so frustrated! I want to easily make a table that summarized my
categorical data (where purchased) by cost. For cost I want to have a column
for sum, count, and average. I am able to get a pivot table that summarizes
this data using one statistical analysis (e.g., sum); however, how do I go
about getting the extra columns that will give me the sum, average, etc. I
want this table to automatically refresh as new data is entered.

Seems to me you can add the cost field three times, using the Sum,
Average and Count functions...
[/QUOTE]

Yes!! This worked! Thank you for your response!!! Yesterday I went back to my pc and created my tables and it was sooo easy. I just switched to the mac a couple months ago and compared to the pc excel it just is not as straightforward - or easy. Even when trying to add the field like suggested I had to drag it to the exact right spot to get it added correctly - a couple times it didn't work.

Now my second problem - if anyone knows an easy solution - I would like to make a table with one categorical variable on the rows, and then a number of column variables. For each column variable I want to display the sum and count. Basically, I think this is like combining a couple of pivot tables together.

Thanks a bunch!