Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running Total per group of items
This will be a very big help. I want a running total of per group of item. The running total will reset to zero until a new group of an item appears next. This is just like RT function in crystal report. Please help. -- Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running Total per group of items
On Apr 21, 12:07 pm, Brightgirl168
wrote: This will be a very big help. I want a running total of per group of item. The running total will reset to zero until a new group of an item appears next. This is just like RT function in crystal report. Please help. -- Thanks! Look in the menu Data:Subtotals. Does that do what you want? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running Total per group of items
Actually we are in manufacturing company. We determining the lacking
parts/items per customer order. In different orders, there are common lacking parts/items. I sort it and group it and use Subtotal but there is no running total per group of item. I don't only need a Subtotal but also need to output a running total per line for each group of item and reset running total per group of item. Please advise. -- Thanks! "Spiky" wrote: On Apr 21, 12:07 pm, Brightgirl168 wrote: This will be a very big help. I want a running total of per group of item. The running total will reset to zero until a new group of an item appears next. This is just like RT function in crystal report. Please help. -- Thanks! Look in the menu Data:Subtotals. Does that do what you want? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running Total per group of items
On Apr 21, 7:00 pm, Brightgirl168
wrote: Actually we are in manufacturing company. We determining the lacking parts/items per customer order. In different orders, there are common lacking parts/items. I sort it and group it and use Subtotal but there is no running total per group of item. I don't only need a Subtotal but also need to output a running total per line for each group of item and reset running total per group of item. Please advise. -- Thanks! "Spiky" wrote: On Apr 21, 12:07 pm, Brightgirl168 wrote: This will be a very big help. I want a running total of per group of item. The running total will reset to zero until a new group of an item appears next. This is just like RT function in crystal report. Please help. -- Thanks! Look in the menu Data:Subtotals. Does that do what you want? I think you'll need to give some more specific info. I can't quite picture what your worksheet looks like. If your data is in a database format, it should be easy to use SUMIF to get what you want. If your item names are in column F, and your dollars in column G, then this should work: =SUMIF(F4:G100,"ProductX",G4:G100) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
Can you use two running total data items to calc a third data item | Excel Discussion (Misc queries) | |||
How do I get Excel to automatically group items? | Excel Discussion (Misc queries) | |||
how to group several items in different groups to be placed in a c | Excel Discussion (Misc queries) |