S
stuart
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...
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...