Announcement

Collapse
No announcement yet.

Calculate average, delete highest and lowest score

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculate average, delete highest and lowest score



    Hi,

    My question is similar to the choosing best of 10 questions. I need to average ratings for a group of seven after deleting the highest and lowest score.

    Thank you for your help.

  • #2
    Hi,

    try

    =(SUM(yourRange)-MAX(yourRange)-MIN(yourRange))/(COUNT(yourRange)-2)

    replace yourRange with actual range.

    hope it helps

    jindon

    Comment


    • #3


      Thank you. I tried it with my data and it does exactly what it was supposed to.

      Comment

      Working...
      X