Count If, criteria is greater than
 

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

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

Count If, criteria is greater than
 

So close

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


--
HTH

Bob Phillips

"Jordan" wrote in message
...
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

Count If, criteria is greater than
 

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

Count If, criteria is greater than
 

=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