sum range values of column depending on criteria

[jumbledore]

I have the following table starting from cell A1 to D6:

1	34	53	8
2	45	76	9
abc	def	ghi	jkl
23	55	96	4
3	51	8	38
mno	pqr	stu	vwx

<tbody>
</tbody>

In cell A9 if I were to enter a value say "stu" it should give me the sum of the 2 rows above. For example if I enter the formula in B9 it should return, 96+8=104. For "ghi", 53+76=129

How do I do so?
Thanks

 

[63falcondude]

How's this?

Excel 2010
	A	B	C	D
1	1	34	53	8
2	2	45	76	9
3	abc	def	ghi	jkl
4	23	55	96	4
5	3	51	8	38
6	mno	pqr	stu	vwx
7
8	Criteria	Sum
9	stu	104
Sheet1

Cell Formulas
Range	Formula
B9	=SUMPRODUCT((A3:D3=A9)*(A1:D2)+(A6:D6=A9)*(A4:D5))

 

[BarryL]

very poor way of doing it is

=IFERROR(SUM(OFFSET(INDEX(6:6,1,MATCH(A11,6:6,0)),-2,0),OFFSET(INDEX(6:6,1,MATCH(A11,6:6,0)),-1,0)),SUM(OFFSET(INDEX(3:3,1,MATCH(A11,3:3,0)),-2,0),OFFSET(INDEX(3:3,1,MATCH(A11,3:3,0)),-1,0)))