You're welcome.

Biff

"Stephen" wrote in message
...
That worked!
Thanks!
--
Thanks!

Stephen


"Biff" wrote:

Hi!

Try this:

=COUNTIF(A1:A10,"<"&A11)

Biff

"Stephen" wrote in message
...
Hi.

I'm trying to do an easy countif formula but it's not working. I want
to
count how many of the cells in a given range are less than another
specific
cell.

I used:

=COUNT(A1:A10,"<A11")

Why won't this work?
--
Thanks!

Stephen