| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
a sum of #'s minus the lowest two values
Interesting variation of the formula I posted:
=SUM(A1:A10,-SMALL(A1:A10,{1,2})) *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Try something like this: =SUM(A1:A10)-SUM(SMALL(A1:A10,{1,2})) Does that help? *********** Regards, Ron XL2002, WinXP "Rynefan" wrote: sum(a3:j3)-min(a3:j3) I know how to not factor in the least number from a string (as shown above) but how do I change the formula to not consider the 2 least values? I am using Excel 2000 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
| Average of an array of entries, minus the lowest entry | Excel Worksheet Functions | |||
Threaded Mode
