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