Sum of Lowest Cell Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One way

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Assume that your cells are in A1:A10.

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

Art
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the lowest number? 3
Change cell color if it is the lowest number of a group? 3
Highlight the lowest number - only if it does not equal another va 6
Highlighting the lowest cell automatically 1
Assign points based on two conditions 1
How to highlight the lowest valued cell in a column in Excel 2003 2
Highlight lowest price in a row. 6
Showing the top result from a range of cells 6

Back
Top