+ Reply to Thread
Results 1 to 2 of 2

Sum ranked values in nonadjacent cells

Hybrid View

  1. #1
    Registered User
    Join Date
    06-18-2007
    MS-Off Ver
    2007
    Posts
    77

    Sum ranked values in nonadjacent cells

    I have 40 nonadjacent rows of unsorted data that is 9 columns wide. The first column is a numerical ranking (1-40) based on one of the columns of data. I would like to sum each of the 8 columns of data, based on the criteria that the entire row is ranked in the top 25. The rankings are reguarly changing based on the data in the one column. All of the data filling the sheet is being looked-up from a pivot table. Thanks.

  2. #2
    Registered User
    Join Date
    06-18-2007
    MS-Off Ver
    2007
    Posts
    77

    Solution Found

    The solution I have found is:

    =SUMIF($A15:$A73,"<=25",D15:D73)

+ Reply to Thread

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