| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel summing N largest values by condition
Hello there,
I'm struggling with an array formula that will return the SUM of the Top 20 values in a list that meet a given criteria. E.g. SUM the Top 20 instances of Dog. Condition Field Data Field Dog 5000 Dog 4954 Cat 4221 Dog 3465 Etc. I can happily return the overall Top 20 using the following array formula: {=SUM(LARGE(Data,ROW(INDIRECT("1:20"))))} However i'm stumped on how to add a condition to the formula. Hope someone can help... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add largest Values | Excel Discussion (Misc queries) | |||
| Sum largest numbers based on condition | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Select Largest 5 in A, AVG values in B | Excel Worksheet Functions | |||
| Summing an array based on text condition | Excel Discussion (Misc queries) | |||
Threaded Mode
