adding up 2 rows if the id and name match in a third column.

[Andrewsh]

not sure I said that right.
I have an odd problem and maybe it has to be taken in steps or can't be done in excel.
I enter time based on projects in excel.
each has a unique project name, but the id may be the same as another project.
the people that use these sheets need it to show one row when that happens, but I still need it split out to show the unique name and id hours split up.

I was hoping that I could force it to check each line and write it in another sheet, and if it matched, add it instead of writing a new row.

I have santized the sheet so I could upload it as is. just different names and project names and id's.

person 6 is a good example. multiple projects, but 2 have the same project id.
is there a way to copy this information into another sheet for each person but add up any duplicate rows?

I tried to do this in stages.
copy over automatically everything from sheet2 to sheet 3 but lable any dupe id's.
then I thought I would check if it was marked dupe before and add it to the previous line marked dupe.
but I can't figure out how to check 2 different things on the same row against 2 different things on another row. I keep getting stuff that cross checks but doesn't check on the same line.


a pivot table doesn't work on this sheet for some reason. I inherited the sheet, and have just been fixing things on it instead of trying to redo the whole thing.


worst case, I have been copying and pasting and adding it all up manually.