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
|