Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combinding two rows into one
I have many rows of data that have duplicatations that I would like to sum
into one consolidation of data. example part # / description / qty 111 / widget 1 / 15 111 / widget 1 / 25 is there a formula that would consolidate the above two rows into this 111 / widget 1 / 40 thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combinding two rows into one
Hi,
You might consider using Advanced Filter with Unique Records selected for the first two columns - which would let you generate a list of unique part#/descriptions. Then you could use either SUMIF or SUMPRODUCT to get the needed totals. SUMIF if the part# and descriptions always match, in which case you would use SUMIF with a part# criteria only. If both columns are needed to define a unique item then use SUMPRODUCT. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Roger" wrote: I have many rows of data that have duplicatations that I would like to sum into one consolidation of data. example part # / description / qty 111 / widget 1 / 15 111 / widget 1 / 25 is there a formula that would consolidate the above two rows into this 111 / widget 1 / 40 thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combinding two rows into one
You could sort your data by part and description,after selecting the whole
area with data from the main menu select: Data - Subtotals Then on the dialog window from the dropdown box select: At each change in: Part# Use Function: Sum Add subtotal to: Qty So you can keep track of the original data or proceed to delete all of the data you wont use by setting up an autofilter and selecting Custom: Does not end with Total -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Roger" wrote: I have many rows of data that have duplicatations that I would like to sum into one consolidation of data. example part # / description / qty 111 / widget 1 / 15 111 / widget 1 / 25 is there a formula that would consolidate the above two rows into this 111 / widget 1 / 40 thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combinding two rows into one
Hi,
You can also work with pivot tables. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Roger" wrote in message ... I have many rows of data that have duplicatations that I would like to sum into one consolidation of data. example part # / description / qty 111 / widget 1 / 15 111 / widget 1 / 25 is there a formula that would consolidate the above two rows into this 111 / widget 1 / 40 thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Combinding cells? | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |