| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum 3 highest numbers
Dear experts,
If I have a selection of four numbers and want to average only the 3 highest what would be the best way to do this? Molly |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum 3 highest numbers
Hi!
Your subject line was Sum 3 highest numbers but your question was to average only the 3 highest. So, here's both: =AVERAGE(LARGE(A1:A4,{1,2,3})) =SUM(LARGE(A1:A4,{1,2,3})) Biff "Molly" wrote in message ... Dear experts, If I have a selection of four numbers and want to average only the 3 highest what would be the best way to do this? Molly |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum 3 highest numbers
Hi,
Thanks so much Biff. Also how do you replicate down a column, a cell with an array formula in it? Sorry terrible English!!! regards Molly "Biff" wrote: Hi! Your subject line was Sum 3 highest numbers but your question was to average only the 3 highest. So, here's both: =AVERAGE(LARGE(A1:A4,{1,2,3})) =SUM(LARGE(A1:A4,{1,2,3})) Biff "Molly" wrote in message ... Dear experts, If I have a selection of four numbers and want to average only the 3 highest what would be the best way to do this? Molly |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum 3 highest numbers
Also how do you replicate down a column, a cell with
an array formula in it? Not sure I understand. Do you mean copy a formula to other cells in a column? If so, select the cell with the formula. Hover your mouse over the bottom right corner of the cell where there appears to be a little black square. Your cursor will change from a fat + sign to a skinny + sign. When the cursor is a skinny + sign, left click and hold down the left mouse button and then just drag down the column. Biff "Molly" wrote in message ... Hi, Thanks so much Biff. Also how do you replicate down a column, a cell with an array formula in it? Sorry terrible English!!! regards Molly "Biff" wrote: Hi! Your subject line was Sum 3 highest numbers but your question was to average only the 3 highest. So, here's both: =AVERAGE(LARGE(A1:A4,{1,2,3})) =SUM(LARGE(A1:A4,{1,2,3})) Biff "Molly" wrote in message ... Dear experts, If I have a selection of four numbers and want to average only the 3 highest what would be the best way to do this? Molly |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum 3 highest numbers
Thank you.
"Biff" wrote: Also how do you replicate down a column, a cell with an array formula in it? Not sure I understand. Do you mean copy a formula to other cells in a column? If so, select the cell with the formula. Hover your mouse over the bottom right corner of the cell where there appears to be a little black square. Your cursor will change from a fat + sign to a skinny + sign. When the cursor is a skinny + sign, left click and hold down the left mouse button and then just drag down the column. Biff "Molly" wrote in message ... Hi, Thanks so much Biff. Also how do you replicate down a column, a cell with an array formula in it? Sorry terrible English!!! regards Molly "Biff" wrote: Hi! Your subject line was Sum 3 highest numbers but your question was to average only the 3 highest. So, here's both: =AVERAGE(LARGE(A1:A4,{1,2,3})) =SUM(LARGE(A1:A4,{1,2,3})) Biff "Molly" wrote in message ... Dear experts, If I have a selection of four numbers and want to average only the 3 highest what would be the best way to do this? Molly |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum 3 highest numbers
You're welcome!
Biff "Molly" wrote in message ... Thank you. "Biff" wrote: Also how do you replicate down a column, a cell with an array formula in it? Not sure I understand. Do you mean copy a formula to other cells in a column? If so, select the cell with the formula. Hover your mouse over the bottom right corner of the cell where there appears to be a little black square. Your cursor will change from a fat + sign to a skinny + sign. When the cursor is a skinny + sign, left click and hold down the left mouse button and then just drag down the column. Biff "Molly" wrote in message ... Hi, Thanks so much Biff. Also how do you replicate down a column, a cell with an array formula in it? Sorry terrible English!!! regards Molly "Biff" wrote: Hi! Your subject line was Sum 3 highest numbers but your question was to average only the 3 highest. So, here's both: =AVERAGE(LARGE(A1:A4,{1,2,3})) =SUM(LARGE(A1:A4,{1,2,3})) Biff "Molly" wrote in message ... Dear experts, If I have a selection of four numbers and want to average only the 3 highest what would be the best way to do this? Molly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How torecord the highest value in a set of constantly changing num | Excel Worksheet Functions | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| How do I add only the highest three numbers in a range of data? | Excel Worksheet Functions | |||
| How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Linear Mode
