Sum of Lowest Cell Numbers

[Anthony]

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

[pinmaster]

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

HTH
JG

[Anne Troy]

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" <[email protected]> wrote in message
news:[email protected]...
>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

[Peo Sjoblom]

One way

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Anthony" <[email protected]> wrote in message
news:[email protected]...
>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

[Art]

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

[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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>