[Solved] Average of the column not including largest value

Discuss the spreadsheet application

[Solved] Average of the column not including largest value

Postby 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
Attachments
Golf-HDCP.ods
(20.24 KiB) Downloaded 9 times
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

Postby Villeroy » Sun Mar 10, 2019 11:42 pm

=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.x
User avatar
Villeroy
Volunteer
 
Posts: 27219
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Average of the column not including the largest value

Postby 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
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

Postby Villeroy » Mon Mar 11, 2019 12:15 am

Golf-HDCP2.ods
(18.17 KiB) Downloaded 11 times
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.x
User avatar
Villeroy
Volunteer
 
Posts: 27219
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Average of the column not including the largest value

Postby blueboss » Mon Mar 11, 2019 12:25 am

Thank you V
OpenOffice 4.1.1
Windows 10
blueboss
 
Posts: 6
Joined: Wed Mar 06, 2019 3:07 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 15 guests