Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum of Lowest Cell Numbers
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 |
#2
|
|||
|
|||
Sum of Lowest Cell Numbers
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" 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 |
#3
|
|||
|
|||
Sum of Lowest Cell Numbers
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Sum of Lowest Cell Numbers
Hi, Try: =COUNTIF(A1:B10,MIN(A1:B10)) HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=477741 |
#6
|
|||
|
|||
Sum of Lowest Cell Numbers
That worked great thank you.
"Peo Sjoblom" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added? | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |