| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating value less minimum numbers in the sequence
I am trying to find a function that will add a series of numbers LESS the 2
lowest numbers in the seqeunce. They are not in order from lowest to smallest as there is more than one group and it is sorted by date. Example: 172 172 172 180 169 180 163 180 175 165 180 175 180 I would need it to pull out the 163 & 165 and add the rest. These numbers will be different for each row and the lowest are not always in the same column. Any ideas?? thanks! Karen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating value less minimum numbers in the sequence
One way
=SUM(A2:M2)-SUM(SMALL(A2:M2,{1,2})) -- Regards, Peo Sjoblom "Karen53" wrote in message ... I am trying to find a function that will add a series of numbers LESS the 2 lowest numbers in the seqeunce. They are not in order from lowest to smallest as there is more than one group and it is sorted by date. Example: 172 172 172 180 169 180 163 180 175 165 180 175 180 I would need it to pull out the 163 & 165 and add the rest. These numbers will be different for each row and the lowest are not always in the same column. Any ideas?? thanks! Karen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating value less minimum numbers in the sequence
This formula should do what you want...
=SUM(A1:M1)-SMALL(A1:M1,1)-SMALL(A1:M1,2) Rick "Karen53" wrote in message ... I am trying to find a function that will add a series of numbers LESS the 2 lowest numbers in the seqeunce. They are not in order from lowest to smallest as there is more than one group and it is sorted by date. Example: 172 172 172 180 169 180 163 180 175 165 180 175 180 I would need it to pull out the 163 & 165 and add the rest. These numbers will be different for each row and the lowest are not always in the same column. Any ideas?? thanks! Karen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating value less minimum numbers in the sequence
=SUM(A1:M1)-SMALL(A1:M1,1)-SMALL(A1:M1,2)
"Karen53" skrev: I am trying to find a function that will add a series of numbers LESS the 2 lowest numbers in the seqeunce. They are not in order from lowest to smallest as there is more than one group and it is sorted by date. Example: 172 172 172 180 169 180 163 180 175 165 180 175 180 I would need it to pull out the 163 & 165 and add the rest. These numbers will be different for each row and the lowest are not always in the same column. Any ideas?? thanks! Karen |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating value less minimum numbers in the sequence
Thank You - that worked perfect!
"Peo Sjoblom" wrote: One way =SUM(A2:M2)-SUM(SMALL(A2:M2,{1,2})) -- Regards, Peo Sjoblom "Karen53" wrote in message ... I am trying to find a function that will add a series of numbers LESS the 2 lowest numbers in the seqeunce. They are not in order from lowest to smallest as there is more than one group and it is sorted by date. Example: 172 172 172 180 169 180 163 180 175 165 180 175 180 I would need it to pull out the 163 & 165 and add the rest. These numbers will be different for each row and the lowest are not always in the same column. Any ideas?? thanks! Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using min function without calculating 0 as minimum | New Users to Excel | |||
| what is the minimum numbers set for 4 digit numbers from 0000 to 9 | Excel Discussion (Misc queries) | |||
| sequence of numbers | Excel Worksheet Functions | |||
| How do I find the minimum NONBLANK value in a sequence of cells? | New Users to Excel | |||
| calculating the minimum value ignoring o | Excel Worksheet Functions | |||
Linear Mode
