Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL formula problem 2

Status
Not open for further replies.
bostjan

bostjan

IS-IT--Management
Apr 23, 2001
7
SI
Hi,

I have 5 numeric values. I must exclude max value and min value and calculate average for the rest three values.

Do you have any suggesstion how to do this?

Bostjan
 
Sort by date Sort by votes
=(SUM(rng)-MIN(rng)-MAX(rng))/(COUNT(rng)-2)

where rng is your data range
 
Upvote 0 Downvote
Hi pbrodsky,

Thanks for your help...formula works fine....
 
Upvote 0 Downvote

pbrodsky,

A star from me, on bostjan's behalf.

Tim



[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
309
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
177
TomSalvato
TomSalvato
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
305
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
299
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
896
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top