Formula 1, could be with:
=(SUM(A1:A100)-MIN(A1:A100)-MAX(A1:A100))/(COUNTA(A1:A100)-2)
What do you consider weighted average. Value x weight factor? If so, do that calculation on another column, and then use that column in the SUM Range (that is, instead of SUM(A1:A100), it can be SUM(C1:C100), this is the column that has the results to your multiplication)
EDIT: Or an array as given by NBVC. With my example you can continue adding values to column A without changing the formula thou
Last edited by ron2k_1; 05-18-2011 at 02:34 PM.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks