Forum Discussion
nbb22
Sep 24, 2023Copper Contributor
Better formula for multi criteria with SUMIFS
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 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
- nbb22Copper Contributor
Thank You Riny_van_Eekelen