#1
|
|||
|
|||
Count max of x values
Is it possible to count only the six largest values from a set of 10 values in a row? |
#2
|
|||
|
|||
Quote:
Sorry, did you mean sum? If so, then yes. =SUMPRODUCT(LARGE(range,{1,2,3,4,5,6})) |
#3
|
||||
|
||||
You'll never cease to astonish me
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
count, max |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count unique values that match 2 or more criteria | caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
Count | Cokeman6 | Excel | 1 | 09-09-2015 08:00 AM |
Display unique values and count the number of child items | vthomeschoolmom | Excel | 2 | 07-25-2013 06:17 AM |
How to count multiple values in a single cell, except zero? | iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |