Keith, what if you did a "vlookup" first and then sunif. this might be a
longer way round but it may work.

"Keith L" wrote:

Excel 2003, what is the formula?

I have 2 columns of data. If there are X's in cells in column 1, I need to
count the number of coresponding cells in column 2 that have a specific
criteria (N/A).

Colimn 1 has an X or is blank, column 2 has 1, 2, 3, 4, 5 or N/A.
--
Thanks
Keith L