any ideas if this can be done

[CarlM]

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

 

[B. R.Ramachandran]

Hi Carl,

Assuming that the seven columns are Columns A, B, ….G, and that the
data start in row 2, enter the following formula in D3, and drag the formula
down to D6 and across to G6 (based on your example)

=IF(SUMPRODUCT(($B$2:$B$8=$C3)*($A$2:$A$8=D$2))=0,"",SUMPRODUCT(($B$2:$B$8=$C3)*($A$2:$A$8=D$2)))

Hope this helps. If it does, please click the Yes button.

With regards,
B. R. Ramachandran

P.S:

It won’t hurt if you modify the formula (such as the one shown below) to
have an extended number of rows of data in the first two columns
=IF(SUMPRODUCT(($B$2:$B$100=$C3)*($A$2:$A$100=D$2))=0,"",SUMPRODUCT(($B$2:$B$100=$C3)*($A$2:$A$100=D$2)))

By the way there is one “error 1†for Carl and two “error 1â€s for Julie in
your sample data, contrary to what you have indicated in your post.

 

[CarlM]

Thank you that worked wonderfully, my boss will be grinning from ear to ear
that it can be done.

Carl