| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum orders in a month from a table
Hi.
I´ve been knocking my head black and blue in desperation... How can I sum orders from a spec month in a table? Cheet A look like this: Col 1: Number of order Col2: Date Col3: Status (A or B) Col4: Projectname Col5: orderamount I want to sum all order from ex nov 2006 into a cell in another cheet (cheet B). My next problem is to sum all orderamount from a spec moutn by Status (A or B). ex. 12 $ in nov 06 and another 14 $ in nov 06 should be sum into 26 $ for nov 06 in the cell on the other cheet. ex. even status should be sum into colums like this: Cheet B Col1: Date each month (ex. nov06, dec 06, jan07 etc) Col2: A project (in $) Col3: B projekt (in $) Col4: A+B projekt (in $) Hope yuo understand my english (I´m from Sweden)... I would be the happiest man in the world if someone could help me... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum orders in a month from a table
From your description it sounds to me like you want a pivot table. Select the
source data and then choose Data - Pivot Table... A wzard will pop up. You can probably just hit finish. it will create a new sheet with a pivot table on it. Drag the amounts to the middle and the dates to the left column. Right click on the datas and select Group. Group by Month, Quarter, Year and anything else you want. Add more fields to the pivot table until it is just the way you want it. You can also add a Format from the pivot table tool bar to make it fancy looking... -- HTH... Jim Thomlinson "Prinsen" wrote: Hi. I´ve been knocking my head black and blue in desperation... How can I sum orders from a spec month in a table? Cheet A look like this: Col 1: Number of order Col2: Date Col3: Status (A or B) Col4: Projectname Col5: orderamount I want to sum all order from ex nov 2006 into a cell in another cheet (cheet B). My next problem is to sum all orderamount from a spec moutn by Status (A or B). ex. 12 $ in nov 06 and another 14 $ in nov 06 should be sum into 26 $ for nov 06 in the cell on the other cheet. ex. even status should be sum into colums like this: Cheet B Col1: Date each month (ex. nov06, dec 06, jan07 etc) Col2: A project (in $) Col3: B projekt (in $) Col4: A+B projekt (in $) Hope yuo understand my english (I´m from Sweden)... I would be the happiest man in the world if someone could help me... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table & Date orders | Excel Worksheet Functions | |||
| orders | Excel Discussion (Misc queries) | |||
| ALLOCATION OF ORDERS - Pivot table | Excel Discussion (Misc queries) | |||
| Sum Order and Vendor Orders from Pivot Table for Given Month | Excel Worksheet Functions | |||
| Purchase Orders | Excel Discussion (Misc queries) | |||
Linear Mode
