Maybe your numbers are being recognized as text. Try...

=ISNUMBER(A2)

If it returns FALSE, try the following...

1) Select an empty cell

2) Edit Copy

3) Select the range of cells containing your numbers

4) Edit Paste Special Add Ok

Does this help?

In article ,
SouthCarolina wrote:

I've tried this equation
{=COUNT(1/FREQUENCY((A2:A6,E2:E6),(A2:A6,E2:E6)))-(COUNTIF(A2:A6,0)+COUNTIF(E2
:E6,0)0)} using the CTRL+SHIFT+ENTER, but the results came out to be zero.

Is there another way?

"SouthCarolina" wrote:

I am trying to count unique entries across a set of colums. For example,

3 4
2 4
4 7
2 1
1 0

I want the result to be 5 as the number of unique entries. Can this be
done?

Thanks