View Single Post
 
Old 07-08-2013, 08:06 PM
dlowrey dlowrey is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 29
dlowrey is on a distinguished road
Default 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
Reply With Quote