## [Solved] Average of the column not including largest value

### [Solved] Average of the column not including largest value

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 .

Thank you Chris
Attachments
Golf-HDCP.ods
Last edited by Hagar Delest on Mon Mar 11, 2019 8:57 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.1
Windows 10
blueboss

Posts: 6
Joined: Wed Mar 06, 2019 3:07 am

### Re: Average of the column not including the largest value

=SUMIF(column;"<"&MAX(column))/COUNTIF(column;"<"&MAX(column))
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 28159
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Average of the column not including the largest value

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
OpenOffice 4.1.1
Windows 10
blueboss

Posts: 6
Joined: Wed Mar 06, 2019 3:07 am

### Re: Average of the column not including the largest value

Golf-HDCP2.ods
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 28159
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Average of the column not including the largest value

Thank you V
OpenOffice 4.1.1
Windows 10
blueboss

Posts: 6
Joined: Wed Mar 06, 2019 3:07 am