Sort by value and Sum

[purchasing]

I'm trying to find a formula that will sort by the data in one column and then sum the quantities specific to the sort in another column.
My spreadsheet looks like this:
A B D
QTY Unit Price Part Number
3 4.29 CD895
3 5.99 CD1095
1 6.19 CD1195
3 6.38 CD1195

I want to sort column D and then have it total all the cells in column A that are associated with the part number.
Thank you

[FDibbins]

to sort, you could use the data/sort from the ribbon, and depending on how you want the totals to look, you could use a variation of sumif()

[MarvinP]

Hi purchasing,

This looks like a Pivot Table problem to me.
http://www.addictivetips.com/windows...-pivot-tables/

[purchasing]

I've tried using the sumif formula however I'm not sure of the variation I would have to use. The data that I have to sort is rather large and from what I can tell you have to put in every "CD895" and so on...

[purchasing]

Pivot tables are not something I've ever used before. I looked at the link and tried but it won't bring over my column that has my part numbers...is this because it's alpha/numeric???

[FDibbins]

i can work out the formula for you, but i noticed that your unit price varies...is that a concern, considering you will be adding volumes with different prices?

[purchasing]

I'm buying CD's at different cost and selling them at a set cost depending on where the unit price falls into my range. I need to first figure out how many I have at CD895... and then an average based on that qty and unit price-hopefully this makes sense

[FDibbins]

see my attachment in my previous post, and letr me lnow if that giveds you what you want? i actually ran a calc for total cost for you as well

[purchasing]

THANK YOU! THANK YOU! THANK YOU! It works I'm so excited!!!!!

[FDibbins]

glad to help

this seems to have anwered your question : please take a moment to mark the tread as "solved", and consider adding the reputation to those that helped (see points 2 & 3 below