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

1

I have two tables in excel, Suppliers and History:

I need to count how many times provider A has committed error A, provider A has committed error B ... and so on, I thought about putting something together with CONT.SES, but the value of providerA and ErrorA should hit two columns on the same line, I can not think of a way to do this ... I would 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 ideas how I can put this together?

    
asked by anonymous 20.06.2017 / 19:20

1 answer

1

In your Result Spreadsheet, enter as B2 as follows:

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

Drag from B2 to D2 and see if it works, then drag to other vendors by adapting the formula.

    
20.06.2017 / 21:41