DSUM frustrations

[Paul Adams]

Thanks, but does not look like DSUM does what I want e.g no way o
getting it to count those bloomin pear tree profits!

I have over a thousand part no's in a spreadsheet and a qty agains
those part no's but I have a problem where there maybe a qty of 8 an
then another row which has the same part no with a qty of 9. what I'
trying to do is get a unique list of part no's with the total qty o
the part no. DSUM looked my best hope but that seems too limited.
My hope was I could have a qty DSUM for each row and the I could delet
the other qty column and the filter it by unique records giving me
list of unique parts no's and total usage's with no duplicates.
Please can anybody help, I don't want to do it by hand.

Thanks

Pau