Group up same values and provide total

[StuartO]

Hi

I have another query. I am trying to create a sheet which I can copy and paste into outlook that provides a component breakdown. To keep it simple for the people that it will be sent to I have concatanated values from a number of cells. At the moment if I have items that are the same the all come in as a seperate line due to the way the information has to be submitted. What I want to do is find a way of totalling all the seperate values together and return them on one line for each different type.

I am sure it can be done, but I am learning as I go and appear to have hit an excel wall!

I have attached a sample workbook, which will hopefully make it a bit clearer.

If anyone can help I'd be really grateful.

[Tank997]

Can you explain which "Types" you want to total? I see several "types" on the sheets. Also sheet 1 is protected so you should turn that off and upload the file again or provide the password for that sheet. An example column(s) that displays the results you have in mind would also help.

[StuartO]

Hi

I have attached the sheet without password and added a required result column as suggested

Thanks for looking at this.

[Tank997]

Does something like this work for you? Since your fist file opened on sheet 1 I was confused by your question.

[StuartO]

Hi
Sorry I don't think I have explained myself very well. The sum if works but I am trying to achieve a reduced list where duplicates are added together rather than displayed on their own (description as well as quantities). Is there someway that excel can reproduce the list with totals added together. I cannot use a filter as I intend on using a filter on the first column that will hide all the 0 values

[Tank997]

Here's another way to create a unique list from column C in column F with a formula, I'm not sure how to only show those items with totals greater than 0, without a filter. You could do it with a pivot table very quickly if that's an option.

BTW the filter I added was just to test the formula and is not needed

[StuartO]

Wow, thats exactly what I wanted. Really appreciate your help, many thanks.

[Tank997]

Stuart, one thing I noticed is it looks like you have several units of measure on at least one of the items which I saw when I was playing with the pivot table I have no idea if this and issue for you or not but I thought I would point it out,