View Single Post
  #5   Report Post  
Art
 
Posts: n/a
Default Sum of Lowest Cell Numbers

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