Syntax to use OFFSET() in a cell formula?
Can you help me correct the syntax?
I am using CountIf() to count occurrences of a string in a range.
=COUNTIF($A$4:$AB$54,TEXT(AD5,"")) <--this works fine.
Now I want to add another condition, whether the cell, 3 cells to the right on the same row, has the string value of "x". I am having trouble using Offset() to make this work.
This formula is broken.
=COUNTIF($A$4:$AB$54,TEXT(AD5,""+TEXT(OFFSET AD5,-3,"x")))
Thank you in advance for help.
-DL
|