Sum and IF and Index function????

[jennyvee]

Can someone help please?

For each unique ID, I need to sum each variable, for multiple variables.

This is what I want the result to look like:
DCN2 - T1016 - H0004 - H0005
123456 - 13 - 4 - 12
111111 - 5 - 0 - 6

This is the data I have:
DCN2 -Code -SumOfUnitsOfService
123456 -T1016 -8
123456 -T1016 -1
123456 -T1016 -4
123456 -H0004 -4
123456 -H0005 -12
111111 -H0005 -2
111111 -H0005 -2
111111 -H0005 -2
111111 -T1016 -2
111111 -T1016 -2
111111 -T1016 -1

[shg]

Welcome to the forum.

You'd be helping yourself if you posted a workbook, Jenny.

[Huron]

I think a pivot table would give the results you want, as shown in the attached file.

[jennyvee]

Thanks for the tip, shg.

Thanks for the answer, Huron.