| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum of top 16 numbers
I'm trying to total only the top 16 scores in a row. I have 1 cell that
'counts' the number of entries and would like to use that as part of this formula. As the events continue, this number will change accordingly. Something like??? if e6<=16,sum(f6:z6),??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
| Validating random numbers | Excel Worksheet Functions | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Threaded Mode
