Try...

=COUNTIF(A2:A8,""&A1)

Hope this helps!

In article ,
"Tbentsen" wrote:

What is the formula for counting cells that has a value larger than the value
of a given cell?

Example: In the range of A2 to A8, how many single cells contain a value
bigger than the value of cell A1

Hope someone out there can help me out! :o)