Using two Vstacks within countif?

[excelNewbie22]

hi,
i'm trying to count combinations of two's from 2 ranges, and want to put it all in one formula rather using helper columns,

=SUM(COUNTIF(vstack(C3&"-"&D3,D3&"-"&E3,E3&"-"&F3,F3&"-"&G3,G3&"-"&H3, C4&"-"&D4,D4&"-"&E4,E4&"-"&F4,F4&"-"&G4,G4&"-"&H4),VSTACK(C2&"-"&D2,D2&"-"&E2,E2&"-"&F2,F2&"-"&G2,G2&"-"&H2)))

but i'm getting an error, saying "there's a problem with this formula" and etc...
any idea why?
any alternatives?

btw, one vstack works fine

 

[Cubist]

Guessing based on your formula. Try

=SUM(--ISNUMBER(XMATCH(C2:G2&"-"&D2:H2,LET(t,TOCOL(E3:H4),DROP(t,-1)&"-"&DROP(t,1)))))

 

[Cubist]

Post #2 doesn't account for duplicates. Redo:

=LET(t,TOCOL(C2:H3),SUM(--(DROP(t,-1)&"-"&DROP(t,1)=C1:G1&"-"&D1:H1)))

 

[excelNewbie22]

thank you Cubist!