Average Function

[ELipp]

I am trying to figure out how to get an average of 4
numbers while dropping the lowest number.

A1 7
B1 10
C1 9
D1 1
E1 Average (solution is 8.67)

I tried the formula =Average(A11)-Min(a1:d1), but it
averages using 4 instead of three. Can't figure out how
to get it to divide by 3 instead of 4.

 

[David J. Braden]

One way:
=(SUM(range)-MIN(range))/(COUNT(rng)-1)

HTH
Dave Braden

 

[Leo Heuser]

Another option:

=AVERAGE(LARGE(A11,{1,2,3}))

 

[Elipp]

When I try the formula I get an error message: #NUM!

 

[Leo Heuser]

I can only get a #NUM! error, if all
cells are formatted as text. Try this:

1. In an empty cell enter 0 (zero)
2. Copy the cell
3. Select the four cells A11
4. Choose Edit > Paste special
5. Choose "Add". OK
6. Press <Esc>

 

[ELipp]

Thanks! It works great!

Emma

-----Original Message-----
I can only get a #NUM! error, if all
cells are formatted as text. Try this:

1. In an empty cell enter 0 (zero)
2. Copy the cell
3. Select the four cells A11
4. Choose Edit > Paste special
5. Choose "Add". OK
6. Press <Esc>

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Elipp" <[email protected]> skrev i en meddelelse


.

 

[Leo Heuser]

You're welcome, Emma.
Your feedback is appreciated.

LeoH