Hi
Need help with a formula to count two adjacent cells on same row like in uploaded file
Hi
Need help with a formula to count two adjacent cells on same row like in uploaded file
Enter "3A" in cell J2.
Enter "1B" in cell K2.
Try this formula:
=COUNTIFS($C$5:$G$14,J2,$D$5:$H$14,K2)
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
Here's another option:
=COUNTIFS(C5:H14,"3A",OFFSET(C5:H14,0,1),"1B")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks