How to sum part number

Hi,

Im new to the whole forum thing and im finding it really difficult to find the answer to my problem so i hope you people can help!!

Ok so i have a document that has 3 coulmns, 1 column of part number, the other of cost and a final column of total. like so:

Part No Cost Total
12345 12
12345 12
4567 5
4567 5
4567 4

This is a very simplified version i have thousands of part numbers sometimes there is 3 or more in a row and sometimes only 1, i have sorted the list via part number and my question is, is there a way of grouping the part numbers and cost, or even better creating a merged cell the length of the 3 part numbers that has a total? so in that case the two rows in the total column of part 12345 would be merged with the total cost across the two rows.

any ideas would be amazing!!

cheers
james

You might look into the Subtotals function under the Data Menu.

Thanks for the quick response guys =) ahhh ok ill research the pivot table option sounds promising
thank you very much
James

Hi again, so i tried to use a pivot table and ended up with the part number (which is what i want and all costs then grouped under the part number) however when i try and subtotal all it writes under each group is part number and then the word sum???? I need a way that will basically sort the data into two colums with part number and total cost. is there a way of doing this??

fre.JPG

(screenshot of my issue)

thanks