Count pairs of values in adjacent columns (either way around)

[Alfie101]

I have pairs of values in adjacent columns. I should like a count of the number of times each pair occurs - either way around, i.e. Mary-Fred OR Fred-Mary. Thx. Example:

Bill Joe 1
Sue Mary 1
Fred Mary 2
Joe Sue 1
Mary Fred 2

[samba_ravi]

C1

Please Login or Register  to view this content.

Try this and copy towards down
Change the range as per your needs

[samba_ravi]

Or
=sumproduct(countifs(a$1:a$5,a1:b1,b$1:b$5,choose({1,2},b1,a1)))