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