Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif for lowerst value within limited to 2 numbers only
A B C D E F G
3 1 2 2 3 4 =i need formula here What the formula to sum only two numbers that have the lowest value of all ( 1 and 2 ). If I three numbers requires for the sum, it should be (1 , 2 and 2 ). Please help. |
#2
|
|||
|
|||
Sum two lowest values... =SUM(SMALL(A1:F1,{1,2})) Sum three lowest values... =SUM(SMALL(A1:F1,{1,2,3})) Hope this helps! ken Wrote: A B C D E F G 3 1 2 2 3 4 =i need formula here What the formula to sum only two numbers that have the lowest value of all ( 1 and 2 ). If I three numbers requires for the sum, it should be (1 , 2 and 2 ). Please help. -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=277305 |
#3
|
|||
|
|||
These formulas are very much helpfull indeed!
Thank you very much. "Domenic" wrote in message ... Sum two lowest values... =SUM(SMALL(A1:F1,{1,2})) Sum three lowest values... =SUM(SMALL(A1:F1,{1,2,3})) Hope this helps! ken Wrote: A B C D E F G 3 1 2 2 3 4 =i need formula here What the formula to sum only two numbers that have the lowest value of all ( 1 and 2 ). If I three numbers requires for the sum, it should be (1 , 2 and 2 ). Please help. -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=277305 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Convert text to numbers | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |