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
|