Syntax to use OFFSET() in a cell formula?

[dlowrey]

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