Count values if values in two columns of the same row are specified

Question

I have two tables in excel, Suppliers and History:

I need to count how many times supplier A made mistake A, supplier A made mistake B... and so on, I thought I’d build something with CONT.SES, but the value of Supplier and Erroa should hit two columns of the same row, I can’t think of a way to do this... I’d rather not use Macro.

I tried something like this:

=CONT.SES(
  Historico!B:C,
  Fornecedores!B1=Historico!B:B,
  Historico!B:C,
  Fornecedores!A2=Historico!C:C
)

Any idea how I can put this together?

Answer 1

In your Result Sheet put as follows in B2:

=CONT.SES(Historico!B:B;$A1;Historico!C:C;B$1)

Drag to B2 for D2and see if it works, then drag to other suppliers adapting the formula.