average of a sort of numbers

B

billy

what i need is a formula, that will take the average of 3 out of 5 numbers , dropping the highest and the lowest numbers
any help would be appreciated.
 
P

Peo Sjoblom

One way

=TRIMMEAN(A1:A5,2/COUNT(A1:A5))

or

=TRIMMEAN(A1:A5,40%)

--

Regards,

Peo Sjoblom

billy said:
what i need is a formula, that will take the average of 3 out of 5 numbers
Click to expand...
, dropping the highest and the lowest numbers
 
B

Bob Umlas

Nice, Peo -- didn't know of that function!

Peo Sjoblom said:
One way

=TRIMMEAN(A1:A5,2/COUNT(A1:A5))

or

=TRIMMEAN(A1:A5,40%)

--

Regards,

Peo Sjoblom

numbers
, dropping the highest and the lowest numbers
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Need help with a formula 3
Findiing highest and lowest in rows and columns 3
Paragraph numbering in Word 1
optimization 1
averaging multiple items from one list 2
Averaging a colume of values. 1
calculate last 4 data points in a column (with sometimes blank rows) 7

Top