Sum of values for multiple criteria

Dear all,

I have the following situation. I have two sheets with the following tables/data:
Sheet 1: Table1

Company Account 1 Account 2 Sum amount
001 220000 221000
002 120000 121000

Sheet 2: Table2:

Company Account Amount
001 220000 $1'000.00
001 221000 $2'000.00
002 120000 $0.00
002 121000 $1'500.00
003 220000 $1'900.00
004 221000 $0.00

What I want to do in the sheet 1, Table 1 (column D):
• Add for each company the total amount for both accounts from sheet 2
• By validating that the company number and two accounts from the sheet 1 correspond to the data in sheet 2 and have then the sum done
I tried doing this by using SUMIFS but it seems that it does not work.
SUMIFS(Table2!C:C;Table2!A:A;Table1!A2;Table2!B:B;Table1!B2&C2)
Could you please help me on this?

Thank you in advance for your answer.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Dear davsth,
Thanks for your reply, here you have the pics with the two sheets I'm currently using.
The question remains the same.

Sheet1:
Sheet 1.PNG

Sheet2:
Sheet2.PNG

Thanks.