software

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

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

quot;Mollyquot; gt; wrote in message
...
gt; Dear experts,
gt; If I have a selection of four numbers and want to average only the 3
gt; highest
gt; what would be the best way to do this?
gt; Molly
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

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Your subject line was Sum 3 highest numbers but your question was to average
gt; only the 3 highest. So, here's both:
gt;
gt; =AVERAGE(LARGE(A1:A4,{1,2,3}))
gt;
gt; =SUM(LARGE(A1:A4,{1,2,3}))
gt;
gt; Biff
gt;
gt; quot;Mollyquot; gt; wrote in message
gt; ...
gt; gt; Dear experts,
gt; gt; If I have a selection of four numbers and want to average only the 3
gt; gt; highest
gt; gt; what would be the best way to do this?
gt; gt; Molly
gt;
gt;
gt;

gt;Also how do you replicate down a column, a cell with
gt;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

quot;Mollyquot; gt; wrote in message
...
gt; Hi,
gt; Thanks so much Biff. Also how do you replicate down a column, a cell with
gt; an array formula in it? Sorry terrible English!!!
gt; regards
gt; Molly
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Your subject line was Sum 3 highest numbers but your question was to
gt;gt; average
gt;gt; only the 3 highest. So, here's both:
gt;gt;
gt;gt; =AVERAGE(LARGE(A1:A4,{1,2,3}))
gt;gt;
gt;gt; =SUM(LARGE(A1:A4,{1,2,3}))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Mollyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Dear experts,
gt;gt; gt; If I have a selection of four numbers and want to average only the 3
gt;gt; gt; highest
gt;gt; gt; what would be the best way to do this?
gt;gt; gt; Molly
gt;gt;
gt;gt;
gt;gt;
Thank you.

quot;Biffquot; wrote:

gt; gt;Also how do you replicate down a column, a cell with
gt; gt;an array formula in it?
gt;
gt; Not sure I understand. Do you mean copy a formula to other cells in a
gt; column? If so, select the cell with the formula. Hover your mouse over the
gt; bottom right corner of the cell where there appears to be a little black
gt; square. Your cursor will change from a fat sign to a skinny sign. When
gt; the cursor is a skinny sign, left click and hold down the left mouse
gt; button and then just drag down the column.
gt;
gt; Biff
gt;
gt; quot;Mollyquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; Thanks so much Biff. Also how do you replicate down a column, a cell with
gt; gt; an array formula in it? Sorry terrible English!!!
gt; gt; regards
gt; gt; Molly
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Your subject line was Sum 3 highest numbers but your question was to
gt; gt;gt; average
gt; gt;gt; only the 3 highest. So, here's both:
gt; gt;gt;
gt; gt;gt; =AVERAGE(LARGE(A1:A4,{1,2,3}))
gt; gt;gt;
gt; gt;gt; =SUM(LARGE(A1:A4,{1,2,3}))
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Mollyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Dear experts,
gt; gt;gt; gt; If I have a selection of four numbers and want to average only the 3
gt; gt;gt; gt; highest
gt; gt;gt; gt; what would be the best way to do this?
gt; gt;gt; gt; Molly
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You're welcome!

Biff

quot;Mollyquot; gt; wrote in message
...
gt; Thank you.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; gt;Also how do you replicate down a column, a cell with
gt;gt; gt;an array formula in it?
gt;gt;
gt;gt; Not sure I understand. Do you mean copy a formula to other cells in a
gt;gt; column? If so, select the cell with the formula. Hover your mouse over
gt;gt; the
gt;gt; bottom right corner of the cell where there appears to be a little black
gt;gt; square. Your cursor will change from a fat sign to a skinny sign.
gt;gt; When
gt;gt; the cursor is a skinny sign, left click and hold down the left mouse
gt;gt; button and then just drag down the column.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Mollyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt; Thanks so much Biff. Also how do you replicate down a column, a cell
gt;gt; gt; with
gt;gt; gt; an array formula in it? Sorry terrible English!!!
gt;gt; gt; regards
gt;gt; gt; Molly
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Your subject line was Sum 3 highest numbers but your question was to
gt;gt; gt;gt; average
gt;gt; gt;gt; only the 3 highest. So, here's both:
gt;gt; gt;gt;
gt;gt; gt;gt; =AVERAGE(LARGE(A1:A4,{1,2,3}))
gt;gt; gt;gt;
gt;gt; gt;gt; =SUM(LARGE(A1:A4,{1,2,3}))
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Mollyquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Dear experts,
gt;gt; gt;gt; gt; If I have a selection of four numbers and want to average only the 3
gt;gt; gt;gt; gt; highest
gt;gt; gt;gt; gt; what would be the best way to do this?
gt;gt; gt;gt; gt; Molly
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;