I'm trying to count the number of occurances in a range based on the
value in the cell.

for example:
a1 has 0.001
a2 has 0.020
...and so on.

I've tried using =countif(myrange,"=a1"), but I get 0 in return. When
I know my range has 0.001 in it.

what the heck am I doing wrong?

Excel 2007