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.