View Single Post
  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Another way

=TRIMMEAN(B73:B77,2/COUNT(B73:B77))

--
Regards,

Peo Sjoblom

(No private emails please)


"Max" wrote in message
...
Or, even <g: =AVERAGE(SMALL(B73:B77,{2,3,4}))
which produces the same results
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----