View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Count If, criteria is greater than

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