| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help Please
I need help setting up a formula to look at a range of data (will vary
between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help Please
One way:
=SUMPRODUCT(--(LARGE(B1:B6,{1,2,3,4}))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "whymj" wrote: I need help setting up a formula to look at a range of data (will vary between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help Please
On Sep 18, 10:34 pm, whymj wrote:
I need help setting up a formula to look at a range of data (will vary between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! Try this. =AVERAGE(LARGE(b1:b6,{1;2;3;4})) This is an array so use control + shift + enter. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help Please
On Sep 18, 10:34 pm, whymj wrote:
I need help setting up a formula to look at a range of data (will vary between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! Try this, =SUM(LARGE(Range,{1;2;3;4})) This is an array so enter wuth Control + Shift + Enter |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help Please
That is exactly what I needed! Thank you for your help!
"Max" wrote: One way: =SUMPRODUCT(--(LARGE(B1:B6,{1,2,3,4}))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "whymj" wrote: I need help setting up a formula to look at a range of data (will vary between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help Please
I got an error message when trying this formula . . . I was probably doing
the Ctrl Shift Enter wrong. Thanks for your response! "SGT Buckeye" wrote: On Sep 18, 10:34 pm, whymj wrote: I need help setting up a formula to look at a range of data (will vary between 4, 5, or 6 values), choose the 4 highest values and add them together (ignoring the rest). ie. b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 b6 = 25 Total = 95 (ignoring 18 & 21) or: b1 = 25 b2 = 18 b3 = 21 b4 = 23 b5 = 22 Total = 91 (ignoring 18) Thanks! Try this, =SUM(LARGE(Range,{1;2;3;4})) This is an array so enter wuth Control + Shift + Enter |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help Please
welcome. thanks for feedback.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "whymj" wrote in message ... That is exactly what I needed! Thank you for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
