Dear FJNS, thank you so much for your excellent fine working solution! As a not so much expert of matrix formulas I will now dedicate myself to study and try to understand the modifications yuo made! To you and this Forum thank you very much again.

Hi,
I'm so glad, the new formula is working well. I also attach another workbook.
The formula for cell V2 on worksheets (Singles, Pairs, Triplets, Quadruplets, Quintuplets, Sextuplets):
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);0);RIF.RIGA($A$2:$A$14)-1)=1;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);0)); RIF.RIGA($A$2:$A$14)-1)=2;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);0)));RIF.RIGA($A $2:$A$14)-1)=3;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=R2 ;RIF.RIGA($A$2:$M$14);0))));RIF.RIGA($A$2:$A$14)-1)=4;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=R2 ;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=S2;RIF.RIGA($A $2:$M$14);0)))));RIF.RIGA($A$2:$A$14)-1)=5;1;0))
=SOMMA(SE(FREQUENZA(SE($A$2:$M$14=O2;RIF.RIGA($A$2 :$M$14);SE($A$2:$M$14=P2;RIF.RIGA($A$2:$M$14);SE($ A$2:$M$14=Q2;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=R2 ;RIF.RIGA($A$2:$M$14);SE($A$2:$M$14=S2;RIF.RIGA($A $2:$M$14);SE($A$2:$M$14=T2;RIF.RIGA($A$2:$M$14);0) )))));RIF.RIGA($A$2:$A$14)-1)=6;1;0))

I hope, it will be easier for you to understand the logic of the formulas.

Attached Files

CountTuples.xlsx (19.6 KB, 13 views)