I need to add prices based on products for comparison in another sheet for 40 vendors.

Sheet1

A B C D
1 Product 1 Product 2 Product 3
2 Vendor A 1200 1400 1500
3 Vendor B 900 1600 1400

Sheet 2

A B
Total Spend
1 Vendor A
2 Vendor B

I was using a SUMIF function in Sheet 2 B2 =SUMIF(Sheet1!A2:A3,B2,Sheet1!B2:D2) and I am only getting the first number in each column (1200, 900, etc) instead of the total (4100, 3900, etc). Am I using the formula incorrectly? Is the syntax incorrect? Any help is greatly appreciated.

Thanks,
John