How many times was Mario accompanied by Alessandro?

[Soleblue]

Good morning guys,
I hope everything is fine. I still need your help with a formula.

I would like to know how many times the name in column A (Manager on duty) has formed the pair with the boy in column AN.

Even if sometimes the same name will be found in column AN, it is not of interest to me.

I manually entered the result I would like.

Could you help me? I hope I was clear
Thanks a lot as always
Sole

I use Office 365 (Italian)

 

[AliGW]

In AR3 copied across and down:

=LET(s,SUMPRODUCT(($A$2:$A$49=$AQ3)*($AN$2:$AN$49=AR$2)),IF(s=0,"",s))

=LET(s;MATR.SOMMA.PRODOTTO(($A$2:$A$49=$AQ3)*($AN$2:$AN$49=AR$2));SE(s=0;"";s))

 

[Soleblue]

Aly thank you so much, you are a magician!
You even took the trouble to write the formula in Italian.
I don't know how to thank you.
I was thinking of a simple "find if..."

Grazie grazie grazie :*

 

[AliGW]

Perfetto - prego!