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
|