Looking for a formula
 

I need some help. I have a spreedsheet with identical numbers with diffrent
qty's in another colume. Is there a quick way to search for the same # and
add the qty's. the sheet is like 2500 lines long and by the looks of it
every part # has a duplicate.

Please help me

No problem. I use this one all the time. You need an array formula.

If your duplicates are in col A, values in col B, and the duplicate value
you want to sum in col C,
put this formula in col D:

=sum(if($A$1:$A$2500=C1, $B$1:$B$2500,0))

Note its an array formula, so you need to hit ctrl+shift+enter to make it
work. Brackets {} should appear around the formula.

HTH

roger



"trisher75" wrote in message
...
I need some help. I have a spreedsheet with identical numbers with
diffrent
qty's in another colume. Is there a quick way to search for the same # and
add the qty's. the sheet is like 2500 lines long and by the looks of it
every part # has a duplicate.

Please help me

Trisher,

A pivot table can give you the total quantities for each number.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"trisher75" wrote in message
...
I need some help. I have a spreedsheet with identical numbers with
diffrent
qty's in another colume. Is there a quick way to search for the same # and
add the qty's. the sheet is like 2500 lines long and by the looks of it
every part # has a duplicate.

Please help me