combining data into subtotal report

A

Amber M

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!
 
D

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.
 
D

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