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.
Bookmarks