Summing with several match index

Hello guys, is there any way to sum results from match index if there are several positive results from the formula itself?
My formula is following:

=INDEX('123YELP'!$1:$1048576;MATCH([@AA];'123YELP'!C:C;0);MATCH([@[BB]];'ABA.xlsx'!Table1[#Headers];0))

It does show me the first match which would be customer A matched with Q1 so value is 100 from below example but I need to sum all results from customer A and Q1 result.

Customer Q1 Q2
A 100 200
A 150 210
A 90 150
A 70 140
B 100 200
B 150 210
B 90 150
B 70 140

Best regards.

Don't use a matching formula to sum. Use a summation formula such as SUMPRODUCT.

Based on your sample, you can use this:

=SUMPRODUCT((A2:A9="A")*(B1:C1="Q1")*(B2:C9))

Hmm it does throw N/A with this formula for some reason:

=SUMPRODUCT((Table1[KONTRAHENT]=B83)*(Table1[[#Headers];[M1]:[YE]]=I83)*('SKU OBRÓT'!I2:AJ4860))

No idea why - never used this formula :/

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

Here is the attachment

The following formula placed in Sheet1!C2 of your sample, returns the desired results that you have shown:

=SUMPRODUCT((Sheet2!A$2:A$14=A2)*(Sheet2!B$1:E$1=B2)*(Sheet2!B$2:E$14))