I have another question, I was wondering how do I get excel to total the
number of cells in a group that have the lowest number. My example is is I
have a group of cells that have 5,6,4,7,2,2,5,6 and and I need to have one
cell count the how many of the lowest numbers are there, for my example there
would be two. If anyone could help, thanks you.

Anthony

You're telling us how many "lowest" numbers you have, but you're not telling
us what determines that. To give you a formula, we need to know (in english)
how you come about determining that. Are you looking for the TWO lowest
numbers? The numbers less than 4? Or what?
************
Anne Troy
www.OfficeArticles.com

"Anthony" wrote in message
...
I have another question, I was wondering how do I get excel to total the
number of cells in a group that have the lowest number. My example is is
I
have a group of cells that have 5,6,4,7,2,2,5,6 and and I need to have one
cell count the how many of the lowest numbers are there, for my example
there
would be two. If anyone could help, thanks you.

Anthony

One way

=COUNTIF(A1:A8,"="&MIN(A1:A8))

--
Regards,

Peo Sjoblom

(No private emails please)


"Anthony" wrote in message
...
I have another question, I was wondering how do I get excel to total the
number of cells in a group that have the lowest number. My example is is
I
have a group of cells that have 5,6,4,7,2,2,5,6 and and I need to have one
cell count the how many of the lowest numbers are there, for my example
there
would be two. If anyone could help, thanks you.

Anthony

That worked great thank you.

"Peo Sjoblom" wrote:

One way

=COUNTIF(A1:A8,"="&MIN(A1:A8))

--
Regards,

Peo Sjoblom

(No private emails please)


"Anthony" wrote in message
...
I have another question, I was wondering how do I get excel to total the
number of cells in a group that have the lowest number. My example is is
I
have a group of cells that have 5,6,4,7,2,2,5,6 and and I need to have one
cell count the how many of the lowest numbers are there, for my example
there
would be two. If anyone could help, thanks you.

Anthony

Assume that your cells are in A1:A10.

Try countif(A1:A10,min(A1:A1))

Art

"Anthony" wrote:

I have another question, I was wondering how do I get excel to total the
number of cells in a group that have the lowest number. My example is is I
have a group of cells that have 5,6,4,7,2,2,5,6 and and I need to have one
cell count the how many of the lowest numbers are there, for my example there
would be two. If anyone could help, thanks you.

Anthony

Hi,
Try:
=COUNTIF(A1:B10,MIN(A1:B10))

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=477741