| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of minimum values in a Range.
I have range of values that I need to extract the sum of the two lowest
values. Kinda a newbie and dont know how to string together functions for this value. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of minimum values in a Range.
=SMALL(A1:A100,1)+SMALL(A1:A100,2)
-- Gary''s Student - gsnu200731 "BiggDC1" wrote: I have range of values that I need to extract the sum of the two lowest values. Kinda a newbie and dont know how to string together functions for this value. Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of minimum values in a Range.
Or
=SUM(SMALL(A1:A100,{1,2})) -- Regards, Peo Sjoblom "Gary''s Student" wrote in message ... =SMALL(A1:A100,1)+SMALL(A1:A100,2) -- Gary''s Student - gsnu200731 "BiggDC1" wrote: I have range of values that I need to extract the sum of the two lowest values. Kinda a newbie and dont know how to string together functions for this value. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Set Minimum Y Axis Values | Excel Worksheet Functions | |||
| The second minimum value in a range | Excel Worksheet Functions | |||
| Return minimum POSITVE value from range | Excel Discussion (Misc queries) | |||
| How do I get "minimum value" in a range to NOT return zero? | Excel Worksheet Functions | |||
| Minimum value in a range > 0 | Excel Discussion (Misc queries) | |||
Linear Mode
