Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting the two lowest numbers
Hi
I am trying to place the two lowest numbers from a selection into a formula eg: selection = 1,3,5,6 Then my formula would be : say 1+3 any ideas??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting the two lowest numbers
The Small function finds the lowest nth item in a range, as in:
=small(a1:a5,1)+small(a1:a5,2) Regards, Fred. "Muz" wrote in message ... Hi I am trying to place the two lowest numbers from a selection into a formula eg: selection = 1,3,5,6 Then my formula would be : say 1+3 any ideas??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting the two lowest numbers
If your values were entered in A1 to D1, then:
=SUM(SMALL(A1:D1,{1,2})) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Muz" wrote in message ... Hi I am trying to place the two lowest numbers from a selection into a formula eg: selection = 1,3,5,6 Then my formula would be : say 1+3 any ideas??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting the two lowest numbers
You have an answer elsewhere - please do not multi-post.
Pete On Jul 29, 1:21*am, Muz wrote: Hi I am trying to place the two lowest numbers from a selection into a formula eg: selection = 1,3,5,6 Then my formula would be : say 1+3 any ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lowest of two closest numbers | Excel Discussion (Misc queries) | |||
Sum of Lowest Cell Numbers | Excel Discussion (Misc queries) | |||
How to sum lowest lanking numbers? | Excel Worksheet Functions | |||
Lowest numbers | Excel Discussion (Misc queries) | |||
I need a formula to add the 3 lowest numbers out of 5. | Excel Worksheet Functions |