How to create a matrix by using multiple criteria to pull values

[guest2013]

Hi,
I have a large dataset containing various values for each variable. I need to construct a matrix which requires using multiple criteria to construct rows and columns of desired matrix. Sample is attached.

I shall be grateful for any help.

Best regards,
G

[ConneXionLost]

How about:

=SUMIFS($D$3:$D$18,$A$3:$A$18,$G3,$C$3:$C$18,I$2)

[guest2013]

Thank you very much. It was great help.

[guest2013]

Thank you very much. It was great help.

[FDibbins]

for the names, use this, copied down...
=INDEX($B$2:$B$18,MATCH(G3,$A$2:$A$18,0))

Then for the rest, use this ARRAY formula, copied down and across...
=IFERROR(INDEX($D$2:$D$18,MATCH($G3&I$2,$A$2:$A$18&$C$2:$C$18,0)),0)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[FDibbins]

post self-deleted