I have a range of multi column data and use CountIf() to count the number of occurrences of text match a particular critera.
For example counting how many times "abc" occurs in the a range of 21 different columns. I have this part working fine.
BUT, we now also need to know if there is an "x" entered in the 3rd column to the right of the cell in which the match is found and; Count only if the value is found.
Below is the part that is working.
=COUNTIF($A$4:$AB$54,TEXT(AD4,""))
My issue is figuring out how to put in a condition so that the cell is not counted unless there is also an "x" in a cell 3 columns to the right, that has me stumped.
Thanks in advance for your help!
-DL
Bookmarks