Then it's likely that the numbers for the remainder of the column are
also being recognized as text. Try the following...

1) Select an empty cell

2) Edit Copy

3) Select Column A

4) Edit Paste Special Add Ok

Does this help?

In article ,
ajajmannen
wrote:

You were correct there It gave a false value but I changed that and got
a TRUE value......but it is still giving the result 0.
Ok to give more information: The vaules in Column A is a 7 digit number
like 1937451. The Value in the N Column can look like this: SE96745 or
like INC-095667.
The numbers in Column A can appear several times and i only want to
count how many unique hits i get.
The values in column N can also be NOXXXXX and DKXXXXX but I only want
to count the unique numbers in Column A that meet the condition SE* or
INC*.
I would like to get.

This formula is really getting on my nerv......And again I want to
thank you for helping out and I hope that we will find the answer:)