Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting/Adding certian cells
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting/Adding certian cells
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. Chance wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't change font color in certian cells. | Excel Discussion (Misc queries) | |||
adding cells then sorting | Excel Worksheet Functions | |||
sorting and adding cells in different work sheet? (hard stuff) | Excel Discussion (Misc queries) | |||
hiding cells with a certian type of formatting | Excel Discussion (Misc queries) | |||
hiding cells with a certian type of formatting | Excel Discussion (Misc queries) |