Results 1 to 11 of 11

Averaging values, excluding minimum value

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2011
    Location
    Antioch, California
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Averaging values, excluding minimum value

    Hello. I am having a problem coming up with a formula to average a set of numbers dropping the lowest of the numbers, then giving equal weight to the remaining 3 numbers. I am a beginning Excel user and cannot figure out how to do this. Example, A1, 95; B1, 80; C1, 70; D1, 60. The value in D1 would be dropped and (95+80+70)/3=81.7 would be the average in cell F1 that I would want calculated by a formula. I just don't seem to be able to figure this out. Any help would be so appreciated! Thank You.
    Last edited by LoriR; 04-22-2011 at 04:04 AM. Reason: To mark as solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1