[Solved] Average of the column not including largest value

blueboss · Post by **blueboss** » Sun Mar 10, 2019 11:25 pm

Hi,

I would like the average value of the columns but as long as there is more than 1 value, not include the largest value in that column when making the average .

I will include my spreadsheet,

Thank you Chris

edit this topic's initial post · Post by **Villeroy** » Sun Mar 10, 2019 11:42 pm

=SUMIF(column;"<"&MAX(column))/COUNTIF(column;"<"&MAX(column))

blueboss · Post by **blueboss** » Mon Mar 11, 2019 12:10 am

Thanks Villeroy,

I'm a beginner, I can see that this is the Total of values, how do I complete the formula to divide by the number in the sample?

Thanks Chris

edit this topic's initial post · Post by **Villeroy** » Mon Mar 11, 2019 12:15 am

Golf-HDCP2.ods: (18.17 KiB) Downloaded 79 times

blueboss · Post by **blueboss** » Mon Mar 11, 2019 12:25 am

Thank you V

[Solved] Average of the column not including largest value

[Solved] Average of the column not including largest value

Re: Average of the column not including the largest value

Re: Average of the column not including the largest value

Re: Average of the column not including the largest value

Re: Average of the column not including the largest value