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?