detect the number in each sector and add the number of positions

[jack]

detect the number in each sector and add the number of positions
in blue are the sum of the number of times the number occurred in each position
https://www.mediafire.com/file/x4lkrs1bjrl1ovg/cruzamento_carteziano.xlsx/file

 

[jack]

You can use this formula in cell BZ6:

=COUNTIFS($Q6:$BW6,"x",$Q$4:$BW$4,BZ$4)

 

[Frank]

https://www.mediafire.com/file/6d8vbfxivoz52on/cruzamento+carteziano.xlsx/file

 

[jack]

huu, ok FRANK, corret! thank you!