counting two ajacent cells on same row

[pedersenn]

Hi
Need help with a formula to count two adjacent cells on same row like in uploaded file

[Phuocam]

Enter "3A" in cell J2.

Enter "1B" in cell K2.

Try this formula:

=COUNTIFS($C$5:$G$14,J2,$D$5:$H$14,K2)

[Pete_UK]

Put this formula in J5:

=SUMPRODUCT(($C$5:$G$14=LEFT($K$2,2))*($D$5:$H$14=RIGHT($K$2,2)))

I get the answer 4, as there is another pair on row 14 which you have not marked.

Hope this helps.

Pete

[Gregb11]

Here's another option:
=COUNTIFS(C5:H14,"3A",OFFSET(C5:H14,0,1),"1B")