Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy/paste Subtotals
Working with a long list of items and sales $$ for each item. Most of the
items have multiple sales per year at different prices.....I want to determine the total sales of a specific item. So..I sort by "item"...subtotal....at each change in "item" use function "sum" on the column which contains the revenue for that specific line item. Im OK until then. Now I need to sort the subtotaled list...so I can determine the highest/lowest selling units. However I can't sort the subtotals....also can't copy/paste the subtotals without all of the background detail going with it. Any solutions ?? Any other functions that may work better ? |
#2
|
|||
|
|||
Hi
- apply subtotal - collaps your data range - select the range - hit F5, click 'Special' and choose 'visible cells only' - now copy and paste -- Regards Frank Kabel Frankfurt, Germany "RichNYC" schrieb im Newsbeitrag ... Working with a long list of items and sales $$ for each item. Most of the items have multiple sales per year at different prices.....I want to determine the total sales of a specific item. So..I sort by "item"...subtotal....at each change in "item" use function "sum" on the column which contains the revenue for that specific line item. Im OK until then. Now I need to sort the subtotaled list...so I can determine the highest/lowest selling units. However I can't sort the subtotals....also can't copy/paste the subtotals without all of the background detail going with it. Any solutions ?? Any other functions that may work better ? |
#3
|
|||
|
|||
Works... Thanks Alot !!!!!
"Frank Kabel" wrote: Hi - apply subtotal - collaps your data range - select the range - hit F5, click 'Special' and choose 'visible cells only' - now copy and paste -- Regards Frank Kabel Frankfurt, Germany "RichNYC" schrieb im Newsbeitrag ... Working with a long list of items and sales $$ for each item. Most of the items have multiple sales per year at different prices.....I want to determine the total sales of a specific item. So..I sort by "item"...subtotal....at each change in "item" use function "sum" on the column which contains the revenue for that specific line item. Im OK until then. Now I need to sort the subtotaled list...so I can determine the highest/lowest selling units. However I can't sort the subtotals....also can't copy/paste the subtotals without all of the background detail going with it. Any solutions ?? Any other functions that may work better ? |
#4
|
|||
|
|||
Hi,
Use two columns for each item,one for sales value and the other for subtotals.{sum($1st sell ref$:next cell ref)} which will give you the subtotal at each stage if reqired.If found useful,pl try. kswarrier "RichNYC" wrote: Working with a long list of items and sales $$ for each item. Most of the items have multiple sales per year at different prices.....I want to determine the total sales of a specific item. So..I sort by "item"...subtotal....at each change in "item" use function "sum" on the column which contains the revenue for that specific line item. Im OK until then. Now I need to sort the subtotaled list...so I can determine the highest/lowest selling units. However I can't sort the subtotals....also can't copy/paste the subtotals without all of the background detail going with it. Any solutions ?? Any other functions that may work better ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Subtotals | Excel Worksheet Functions | |||
Sorting a list with subtotals | Excel Worksheet Functions |