I have two spreadsheets in the same work book. page one is a listing from and
export and need to get totals on a seperate worksheet.

error 1 Carl error 1 error 2 error 3 error 4
error 2 Julie Carl 2 1
error 1 Julie Julie 1
error 3 Ariel Ariel 1
error 4 Stephanie Stephanie 1
error 2 Carl
error 1 Julie

the first two colums is the output of the export I can modify if it makes it
easier to error across the top of columns and names as rows.

the next five columns are the total page and trying to figure if there is a
worksheet function that can total each error for each person, not sure if
vlookup or another function will work and I am open to all suggestions.
Thanks very much in advance.
error 1 Carl