Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Don't need SP< SUM is sufficient
=SUM(SMALL(rng,{1,2})) -- __________________________________ HTH Bob "Infinitogool" wrote in message ... Hi Muz Try: =SUMPRODUCT(SMALL(range,{1,2})) Regards, Pedro J. Hi I am trying to write a formula using the two lowest numbers from a selection where say x=lowest and y=second lowest =x+y any suggestions? ps. x and y may sometimes be the same number |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
display lowest values | Excel Worksheet Functions | |||
Find lowest 3 values and sum | Excel Worksheet Functions | |||
Average of lowest 5 of 20 values? | Excel Worksheet Functions | |||
taking out lowest 2 values | Excel Worksheet Functions | |||
How can I identify the two lowest values in a row? | Excel Worksheet Functions |