countifs for one range with multiple citeria

[qwertkiba]

HI guys,
i need to count how many times a combination of two numbers appears in a 5-column array.

the formula used in the result cells is this :
=COUNTIFS(A2:E9,"="&F2,A2:E9,"="&G2)
In that purpose all result cells should show 1.
Any ideas to achieve that?
thank you.

 

[bbott]

Welcome to the board.

Try:

=SUMPRODUCT(--(A2:E10=F2))+SUMPRODUCT(--(A2:E10=G2))

 

[qwertkiba]

Welcome to the board.

Try:

=SUMPRODUCT(--(A2:E10=F2))+SUMPRODUCT(--(A2:E10=G2))

thanx mate , but it doesn't work for me.
I need to count how many times 2 numbers appear in the same row .