View Single Post
  #3   Report Post  
Stephen
 
Posts: n/a
Default

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