SUMIF questions

**Johnny Image** · 06-18-2013, 07:01 PM

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

**oeldere** · 06-18-2013, 07:07 PM

Not sure if that syntax will work.

sumif(A2:a500,b2,c2:c500)

but why you not just sum the totals on sheet 1m since you have the data in rows for each vendor.

**Tony Valko** · 06-18-2013, 07:10 PM

You can't use the SUMIF function for this.

One way...

Entered in cell B2 on Sheet2:

=SUM(INDEX(Sheet1!B$2:D$3,MATCH(A2,Sheet1!A$2:A$3,0),0))

Copy down as needed.