Sum Extract data from list that match multiple criteria

[callao2908]

Good morning, thanks for such a good example.

FORMULA FORENSICS 3b

What I want to know is that formula should be used,
so instead of seeing the list that includes vegetables
that are repeated, only the accumulated. Example:

Output Quantity
Potato 29
Spinach 72
Peas 19
Broccoli 21

Spinach It is the sum of 39 plus 33, the two that are
repeated, and so for all cases that repeat

See the explanations in the attached file, which is the same as Formula Forensics 3b

Thanks for the attention (Translate by Google Translate)

Jorge from Peru

 

[AlanSidman]

A Pivot Table will do exactly as you wish. I have added one your file.

 

[callao2908]

Thanks Alan, I did it that way, but I need it to be with normal or matrix formulas
Regards

 

[Nebu]

Hi:

Use SumIfs formula for this.

Thanks

 

[callao2908]

Nebu thank you very much, although the answer you give me is correct in part, since if I continue using the formula to get the results under the OUTPUT column, they would be repeating the vegetables that are repeated as is the case of Spinach, and therefore would have a result that doubles, you will see it highlighted.

Output Quantity
Potato 29
Spinach 72
Peas 19
Broccoli 21
Spinach 72

Please, correct the formula to obtain the results below the OUTPUT column, without repeating itself in such a way that the final result will be like this.
Output Quantity
Potato 29
Spinach 72
Peas 19
Broccoli 21



Thank you very much in advance.
regards

 

[bosco_yip]

...to obtain results as the below OUTPUT column, without repeating itself ..
Output Quantity
Potato 29
Spinach 72
Peas 19
Broccoli 21

Try...........

1] In "Output" I2, formula copy down :

=IFERROR(INDEX(D$2:D$25,MATCH(1,INDEX(ISNA(MATCH(D$2:D$25,I$1:I1,0))*(A$2:A$25=G$6)*(B$2:B$25=G$9)*(C$2:C$25=G$3),0),0)),"")

2] In "Quantity" J2, formula copy down :

=IF(I2="","",SUMIFS(E:E,A:A,G$6,B:B,G$9,C:C,G$3,D:D,I2))

Regards
Bosco

 

[callao2908]

Thanks Bosco, until another opportunity. They can close the subject
Regards
Jorge desde Perú