Results 1 to 8 of 8

Adding up the top 8 values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    346

    Adding up the top 8 values

    Morning,

    I posted an earlier query asking how to work out the average value from the highest 8 values from a row of 12. The boss has now said we don't need an average just a total

    In cell Q2, I would like it to look at all the values in cells in B2 to N2, and then add up the highest 8 scores; if there are less than 8 values, I would like it to add up what there is.

    Any help would be appreciated.

    Many thanks
    Attached Files Attached Files
    Last edited by Cmorgan; 07-02-2012 at 11:38 AM.

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