Sorting/Adding certian cells

  • Thread starter Thread starter Chance
  • Start date Start date
C

Chance

I'm creating a summary cost sheet using 2 sheets in a
workbook. Sheet1 is my P.O. Log and sheet2 will gather
information from sheet1. I'm wondering if I have my P.O.
log setup as follws:

Date Vendor Description Amount Catagory

Then on sheet2 I would have a list of all the catagories.
Is there a way to have it add all the amounts for each
catagory from sheet1 and place the totals under the right
catagory on sheet2. There will be somewhere around 20
catagories.

Thanks,
Chance
 
You could apply Data|filter|autofilter to your range to limit the info shown.

But you may want to select your range and then Data|Pivottable.

follow the wizard until you get to the dialog sheet with Layout on it.
click on that button.
Drag the Category header to the Row field.
Drag the Amount to the Data field.
If the Amount turns to "count of Amount", double click on it and change it to
"Sum of Amount"

Play around with that layout. You can do lots of neat things. Drag vendor on
top of Category and see what it does.

When you're looking at the pivottable, those grey buttons are "hot". You can
drag them around. Try dragging the vendor to the right of category and watch
the pivot table change.
 
Back
Top