Excel 2007 : Countif function Not working correctly

Hello
I'm really glad I found this forum thanks in advance for any assistance as I am an excel Junkie and spend countless hours using it. My dilemma is this:
I am trying to use the countif function for numbers that are not whole and derived from a formula. Ive found that it works if I just type the value in it will be counted but when a formula calculates it it is not counted. I am sure it is a formatting issue but it has eluded me. IE None of the below numbers are counted using =Countif(A1:A10,"2.962496068") - thanks in advance for any help.

1.44224957
1.709975947
-3
2.962496068
-1.912931183
-2.223980091
1.587401052
2.15443469
1.709975947

Try without quotes around number

no that didnt help

I probably should mention that when I highlight the cell the formula that is in there is =R21^(1/3) which shows up in the formula bar

How about:

=SUMPRODUCT(--(LEFT(A1:A10,11)="2.962496068"))

I assume he can't count them because they are actually different lenght...

2^(1/3) is 1,25992104989487 so counting 1,259921 will give you 0

example workbook would be the best.

Edit: he, not you

Hi Zbor - none of those suggestions worked. I also heard countif doesn't work with negative #'s - have you heard this? Also how do you submit a sample workbook?
thanks

In a post click Go Advanced, click Paper clip icon and then upload file.

Write your input and desired result.

ill try that thx!@

FDibbins
How would you formula that?
=countif(a1-a20),=2^(1/3)? Something like that ?
thanks