help adding/filtering same items in rows

I have multiple equal entries in Column A and I need to add up its quantities and summarize it into 1 row. column A is a userid, columns B, C, D are #'s of error types. would it be possible to filter out the id's into 1 row with all its totals added up for B, C, and D. and then the SUM of B, C, D in column E?

for example:

Raw data

col A B C D
ID error type 1 type2 type3
1234 2 1 4
4321 1 4 3
1234 2 3 1
4321 1 1 4

solution would be:

col A B C D E
ID error type 1 type2 type3 Total
1234 4 4 5 13
4321 2 5 7 14


Thanks in advance for taking the time to look at this.

Hi

Have a look at Pivot Tables. Seems to be ideal for what you want to do.

rylo

Pivot Table example attached

Thanks guys, but is there a way to do this so its in a cell format as opposed to a pivot table? I saw 1 on here that would work but it only used 2 columns and I'm not savvy enough to figure out how to change it. Here's the link to that post:
http://www.excelforum.com/excel-prog...s-in-rows.html

Try this,

H2

Please Login or Register  to view this content.

committed with Ctrl+Shift+Enter

I2

Please Login or Register  to view this content.

J2

Please Login or Register  to view this content.

K2

Please Login or Register  to view this content.

L2

Please Login or Register  to view this content.

Copied down.

You can also see attached file.

Hope this helps,
windknife