Hi, I'm looking for a formula that will average 5 numbers, getting rid of the High and the Low numbers. Any help is greatly appreciated.
Hi, I'm looking for a formula that will average 5 numbers, getting rid of the High and the Low numbers. Any help is greatly appreciated.
Hi and welcome to the forum
you need to look at using averageifS() and incorporating <>min() and <>max()
If your data is in A1:A5, try...
=AVERAGEIFS(A1:A5,A1:A5,"<>"&MIN(A1:A5),A1:A5,"<>"&MAX(A1:A5))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That method may not work if there are duplicate numbers....
TRIMMEAN function averages without "outliers" - try
=TRIMMEAN(A1:A5,2/COUNT(A1:A5))
which can be extended to any size range....or for 5 numbers
=AVERAGE(SMALL(A1:A5,{2,3,4}))
Audere est facere
Thank you both, that works great daddylonglegs!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks