Lookup question

[drluke]

I'm attempting to do a lookup from data organised like:
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Name[/TD]
[TD]7755[/TD]
[TD]7756[/TD]
[TD]7757[/TD]
[/TR]
[TR]
[TD]Hill[/TD]
[TD]100.00[/TD]
[TD]25.00[/TD]
[TD]98.00[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]10.26[/TD]
[TD]896.57[/TD]
[TD]3215.14[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]18.76[/TD]
[TD]12.00[/TD]
[TD]47.86
[/TD]
[/TR]
[TR]
[TD]Hill[/TD]
[TD]56.98[/TD]
[TD]25.47[/TD]
[TD]33.59[/TD]
[/TR]
[TR]
[TD]Brown[/TD]
[TD]1254.26[/TD]
[TD]8569.24[/TD]
[TD]4529.10[/TD]
[/TR]
[TR]
[TD]Hill[/TD]
[TD]5869.25[/TD]
[TD]5689.24[/TD]
[TD]1.56[/TD]
[/TR]
</tbody>[/TABLE]

In my lookup sheet I have the names in columns, and the name is the only thing in common between the 2 tables. What formula can I used to sum the total of all sales made by Hill for all 3 categories?

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Hill[/TD]
[TD]Smith[/TD]
[TD]Black[/TD]
[TD]Brown[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Name	cat 1	cat 2	cat 3					Name	Hill	Smith	Black	Brown
2	Hill	100	25	98					Total	11899.09	4121.97	78.62	14352.6
3	Smith	10.26	896.57	3215.14
4	Black	18.76	12	47.86
5	Hill	56.98	25.47	33.59
6	Brown	1254.26	8569.24	4529.1
7	Hill	5869.25	5689.24	1.56
Sheet10

Cell Formulas
Range	Formula
J2	{=SUM(MMULT(TRANSPOSE($B$2:$D$7),--($A$2:$A$7=J$1)))}
K2	{=SUM(MMULT(TRANSPOSE($B$2:$D$7),--($A$2:$A$7=K$1)))}
L2	{=SUM(MMULT(TRANSPOSE($B$2:$D$7),--($A$2:$A$7=L$1)))}
M2	{=SUM(MMULT(TRANSPOSE($B$2:$D$7),--($A$2:$A$7=M$1)))}
Press CTRL+SHIFT+ENTER to enter array formulas.