Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help creating Formula (or macro)
I have a range of five numbers, say A1:A5.
I want to identify the three lowest numbers in that range, and then return the sum of those three numbers. Was trying to use sumif, but could not figure it out. I then set up a simple (follow me) macro which copied the range, pasted the values, then sorted, and then I just added the bottom three cells. That works fine, except I have 30 such ranges, and cannot now figure out how to step the macro to the next range (it keeps returning to the original range), hence why I am trying to do this through a formula. Any help would be appreciated. -b |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help creating Formula (or macro)
Hi!
Try this: =SUM(SMALL(A1:A5,{1,2,3})) Biff "bman342" wrote in message ... I have a range of five numbers, say A1:A5. I want to identify the three lowest numbers in that range, and then return the sum of those three numbers. Was trying to use sumif, but could not figure it out. I then set up a simple (follow me) macro which copied the range, pasted the values, then sorted, and then I just added the bottom three cells. That works fine, except I have 30 such ranges, and cannot now figure out how to step the macro to the next range (it keeps returning to the original range), hence why I am trying to do this through a formula. Any help would be appreciated. -b |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help creating Formula (or macro)
Biff:
Works like a charm, thanks so much. -b "Biff" wrote: Hi! Try this: =SUM(SMALL(A1:A5,{1,2,3})) Biff "bman342" wrote in message ... I have a range of five numbers, say A1:A5. I want to identify the three lowest numbers in that range, and then return the sum of those three numbers. Was trying to use sumif, but could not figure it out. I then set up a simple (follow me) macro which copied the range, pasted the values, then sorted, and then I just added the bottom three cells. That works fine, except I have 30 such ranges, and cannot now figure out how to step the macro to the next range (it keeps returning to the original range), hence why I am trying to do this through a formula. Any help would be appreciated. -b |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help creating Formula (or macro)
You're welcome. Thanks for the feedback!
Biff "bman342" wrote in message ... Biff: Works like a charm, thanks so much. -b "Biff" wrote: Hi! Try this: =SUM(SMALL(A1:A5,{1,2,3})) Biff "bman342" wrote in message ... I have a range of five numbers, say A1:A5. I want to identify the three lowest numbers in that range, and then return the sum of those three numbers. Was trying to use sumif, but could not figure it out. I then set up a simple (follow me) macro which copied the range, pasted the values, then sorted, and then I just added the bottom three cells. That works fine, except I have 30 such ranges, and cannot now figure out how to step the macro to the next range (it keeps returning to the original range), hence why I am trying to do this through a formula. Any help would be appreciated. -b |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Custom button to fill in the same formula | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Macro Formula revision? | Excel Worksheet Functions |