Sumifs with multiple columns - Possible Vlookup needed

[danvorn]

I have data that I need to sum together and then use a vlookup to assign to an individual. I have been trying to use SUMIFS to use a double criteria, but it hasn't been working. Any ideas?

I want to be able to use a formula to pull and summarize the data below as follows

	Cost A	Cost B	Cost C
Jeff	150	100	150
Jay	150	100	150
Kaylie	150	100	150

<tbody>
</tbody>

Here is an example of the data.

		Jeff	Jay	Kaylie
A	Cost A	50	50	50
A	Cost A	100	100	100
C	Cost C	50	50	50
C	Cost C	100	100	100
B	Cost B	25	25	25
B	Cost B	75	75	75

<tbody>
</tbody>

 

[bbott]

Welcome to the board.

Have you tried using a pivot table?

 

[danvorn]

No, I need to export the data into a different table and can't manipulate the original data.

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
1​			Jeff	Jay	Kaylie			Cost A	Cost B	Cost C
2​	A	Cost A	50​	50​	50​		Jeff	150​	100​	150​
3​	A	Cost A	100​	100​	100​		Jay	150​	100​	150​
4​	C	Cost C	50​	50​	50​		Kaylie	150​	100​	150​
5​	C	Cost C	100​	100​	100​
6​	B	Cost B	25​	25​	25​
7​	B	Cost B	75​	75​	75​

H2, copied across and down:

=SUMIFS(INDEX($C:$E,0,MATCH($G2,INDEX($C:$E,1,0),0)),$B:$B,H$1)

 

[GerryZ]

try this formula!

Book1
	A	B	C	D
1		Jeff	Jay	Kaylie
2	Cost A	50	50	50
3	Cost A	100	100	100
4	Cost C	50	50	50
5	Cost C	100	100	100
6	Cost B	25	25	25
7	Cost B	75	75	1
8
9
10		Cost A	Cost B	Cost C
11	Jeff	150	100	150
12	Jay	150	100	150
13	Kaylie	150	26	150
Foglio2

Cell Formulas
Range	Formula
B11	=SUMPRODUCT($B$2:$D$7*($A$2:$A$7=B$10)*($B$1:$D$1=$A11))

 

[danvorn]

Wow! Thank you! I have no idea how that works...but it did!

 

[Aladin Akyurek]

Wow! Thank you! I have no idea how that works...but it did!

You are welcome.