| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i get the 3 highest in a range
=SUM(LARGE(A1:A100,ROW(INDIRECT("1:"&MIN(20,COUNT( A1:A100))))))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "SonicBro1" wrote in message ... This was helpful. I am doing the same thing but will have ranges that are not the same. IE: Looking to sum the top 20 when some have 25#s & others have less than 20. Halp! "Roy" wrote: YES! in stead of an formula that is huge, I now have this little formula. BIG THANKS /Roy Biff skrev: Hi! Try this: =SUM(LARGE(A1:A10,{1,2,3})) Biff "Roy" wrote in message ... Hi, I have a range of 10 numbers. How can I get the sum of the 3 highest numbers in a range? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| How do I add only the highest three numbers in a range of data? | Excel Worksheet Functions | |||
Threaded Mode
