combining data into subtotal report

[Guest]

I need to manually enter data under various categories. (i.e. column A will
be Job # and the other columns will contain the counts of various supplies),
creating a very large running total of jobs and total supplies. It is
important to realize that I may enter the same job # with new data more than
one time. Now, I understand how to create subtotals of columns, but I was
wondering if, once I have sorted data by job #, there is a way to create a
fast and easy report that indicates ONLY the column headings and each job's
subtotal. I do not want to see the 25 different entries that it took to
create that job number's subtotal. Any ideas? Thanks!

 

[Debra Dalgleish]

If you use the Subtotals feature (Data>Subtotals) to summarize the data,
you can hide the details, and show only the subtotals.

Or create a pivot table from the data. Jon Peltier has Pivot Table
information and links on his site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

and there's some information here:

http://www.contextures.com/xlPivot01.html

 

[Guest]

How do I hide the details?

If you use the Subtotals feature (Data>Subtotals) to summarize the data,
you can hide the details, and show only the subtotals.

Or create a pivot table from the data. Jon Peltier has Pivot Table
information and links on his site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

and there's some information here:

http://www.contextures.com/xlPivot01.html

 

[Dave Peterson]

There are outlining symbols to the left of the row numbers. You can use the
symbols at the top level to hide/show each level.

Or use the +/-'s to show just that group's details.

 

[Guest]

What if I have over 200 subtotals? Is there a faster way? Thanks!

 

[Dave Peterson]

Use those symbols at the top to show just the totals. They're little box like
things with numbers in them. (Directly under the NameBox--to the left of the
formula bar.)

But take a look at the pivottable stuff that Deb suggested. You can get very
nice summary reports using this builtin tool.

 

[Guest]

Okay, Dave. I see what you meant by using the symbols. Thank you so much!