How do I write a formula to count duplicate x,y coordinates?

[arthurz11]

In cell G1 and G2 you input the x or y coordinates. In cell G6 it displays the count(s) x,y coordinates from range A2:D4. How do you write the count formula in cell G6? If there is only one x,y coordinate it displays a 1. If the x,y coordinate does not exist in the range, then it displays a 0.

 

[Joe4]

Try this formula:

=COUNTIFS(A2:A4,G1,B2:B4,G2)+COUNTIFS(C2:C4,G1,D2:D4,G2)

 

[arthurz11]

Try this formula:

=COUNTIFS(A2:A4,G1,B2:B4,G2)+COUNTIFS(C2:C4,G1,D2:D4,G2)

Worked awesome!!!! Thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!