Function question
 

I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale

This formula will count all the numbers in column A below 10
=COUNTIF(A:A,"<10")

Conditional Formatting will bold those numbers...........Format
Conditional Formatting then follow the menu.........

Vaya con Dios,
Chuck, CABGx3


"Dale Rosenthal" wrote in message
...
I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale

Dale,

The answer to your first question is that the COUNTIF function appears to
be what you are looking for.

For the second question, conditional formatting is your key. It's at
FormatConditional Formatting.

"Dale Rosenthal" wrote:

I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale

See answers to your other post in "newusers".

Please don't multipost.
Most folks here read all the NGs
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Dale Rosenthal" wrote in message
...
I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale

To those who helped,

Thanks so much. My wife and I got the Countif function earlier but the
conditional formatting was spot on. Thanks again.

Dale

On 1/24/05 6:45 PM, in article
, "Roland"
wrRoland wrote with the prose of a poet
laureate:

Dale,

The answer to your first question is that the COUNTIF function appears to
be what you are looking for.

For the second question, conditional formatting is your key. It's at
FormatConditional Formatting.

"Dale Rosenthal" wrote:

I know I'm not going to ask this correctly. I have a column of numbers. I
wish to have a count at the bottom of the column of the number of numbers
that fall below a certain number. What function is this? Or, is there a
website that would tell me how to do this?

Second question: Same column of numbers. Is there a way to have those same
numbers that fall below a given number become bold?

Thanks so much.

Dale