Try it like this:

=countif(myrange,a1)

The way you had it the formula was looking for the literal string
"a1", rather than the contents of A1. The = is implied, and so not
needed.

Hope this helps.

Pete

On Nov 10, 12:04*am, Nondisclosure007
wrote:
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