=COUNTIF(BE33:EZ33,"<"&FE33) + Countif(BE33:EZ33,""&FF33)


=SUM(COUNTIF(BE33:EZ33,{"<"&FE33,""&FF33}))

--
Regards,
Tom Ogilvy


"Jordan" wrote in message
...
Hey Dave,
You are AWESOME!!!

Do you know how I can get it do to multiplue criteria? something like:

=COUNTIF(BE33:EZ33,"<"&FE33 OR ""&FF33)





"Dave Peterson" wrote:




Or something like:

=COUNTIF(BE33:EZ33,"<"&FE33)

(note the additional ampersand (&).)



Jordan wrote:

I have a group of numbers and I need to know what number of them are
less
than the value in another cell.
Should look something like this:
=COUNTIF(BE33:EZ33,""<FE33) or
=COUNTIF(BE33:EZ33,"<FE33") or
=COUNTIF(BE33:EZ33,"<"FE33)

I don't know. Basically I want to know the number of cells that have
values
less than FE33. And of course FE33, and many of the other cells are
formulas
themselves.

Thanks,
Jordan

--

Dave Peterson