Better formula for multi criteria with SUMIFS

[nbb22]

Hi there.

Hope you can help me to improve my formula.

Here are my data

Product	Price
Product A	15
Product B	100
Product B	20
Product A	30
Product A	50
Product B	30
Product A	20
Product A	100
Product B	50
Product A	20
Product C	50

For calculating the sum of "product A" priced 20 or 50, I use (in french) SOMME.SI.ENS(B2:B12;A2:A12;"Product A";B2:B12;20)+SOMME.SI.ENS(B2:B12;A2:A12;"Product A";B2:B12;50).

Is there a better / more compact formula to do this?

And, how can I sum "product A" and "product B" priced 20 or 50 without a long formula?

Thanks for you answer.

[#2 · Accepted solution]

@nbb22 Consider using a structured table with a total row and slicers.

[#3]

Thank You @Riny_van_Eekelen